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 |
|
unsavory
Starting Member
1 Post |
 Posted - 2002-11-06 : 21:21:26
|
| Two questions for everyone. First of all, is it safe to use the killdatabase method? By safe, I don't mean what if I accidently kill the wrong one, but I mean can it harm the database server or master database itself or cause Sql Server to become unstable?Second question:Can someone please show me a T-SQL statement(program) to call this method and kill a database? |
|
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
Posted - 2002-11-08 : 16:58:57
|
quote:
Two questions for everyone. First of all, is it safe to use the killdatabase method? By safe, I don't mean what if I accidently kill the wrong one, but I mean can it harm the database server or master database itself or cause Sql Server to become unstable?Second question:Can someone please show me a T-SQL statement(program) to call this method and kill a database?
Try this link: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqldmo/dmoref_m_k_2r6s.aspDanielSQL Server DBA |
 |
|
|
|
|
|
killdatabase... Is it safe?