Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-17 : 10:00:18
|
| Brian writes "Hello,I receive a bunch a databases from a vendor of mine that I need to attach to my SQL server and then import that data to another database. I have had no problems, until now. When I go to attach the database I receive this error;Could not open new database 'SBMA'. CREATE DATABASE is aborted.Device activation error. The physical file name'C:\MSSQL7\data\sbma.LDF' may be incorrectI am running sql2k, so why is it trying to put this here in this folder??? Am i doing something wrong??" |
|
|
royv
Constraint Violating Yak Guru
455 Posts |
Posted - 2002-07-17 : 10:45:50
|
| Make sure that the vendor detached the database. If the vendor did, show us your DML and we'll take a look at it.*************************Someone done told you wrong! |
 |
|
|
|
|
|
attach database