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 |
|
rajasekhar857
Constraint Violating Yak Guru
396 Posts |
 Posted - 2009-08-25 : 02:13:50
|
| Hi,iam having one database which is in single user mode. now i don't want that can i directly give delete on that to drop it from sql server 2005 or is there any other procedure.because i am not sure if i delete direcly it effects any other databases?please suggest me. |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
Posted - 2009-08-25 : 02:22:49
|
| alter table to multiple user and dropALTER DATABASE [Works] SET MULTI_USER WITH NO_WAITelselogin to the SA and drop the db Both does't affect other DBsSenthil.C------------------------------------------------------[Microsoft][ODBC SQL Server Driver]Operation canceledhttp://senthilnagore.blogspot.com/ |
 |
|
|
lionofdezert
Aged Yak Warrior
885 Posts |
Posted - 2009-08-25 : 02:23:47
|
| Why it should effect other databases ? Nothing will happen to other databases. You can drop a database which is no more required. |
|
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2009-08-25 : 16:41:32
|
| If you drop one database, that will not affect other databases. |
|
|
|
|
|
|
dropping single user mode database