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.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  Can't Kill Database

Author  Topic  jhunt Starting Member 21 Posts Posted - 2002-02-22 : 01:21:08 Hi there I am using SQL-DMO in an application we are writing. When I use the Database objects remove method, every so often we get an error saying that the database is being used. (Though it is not, at least not by another user). So I resorted to using the SQL-DMO server object's KillDatabase method since there seemed less chance of an error occurring on a clients machine. However the server object merely reports that the database does not exist. Some code is pasted below. Can somebody help me with either of these methods of deleting a database? Thanks justin Remove =========== Dim objDatabase As Database Dim m_SQLServer As SQLDMO.SQLServer Set m_SQLServer = New SQLDMO.SQLServer m_SQLServer.LoginTimeout = 15 m_SQLServer.LoginSecure = False Call m_SQLServer.Connect("MyServer","sa","")) Set objDatabase = m_SQLServer.Databases("MyDatabase") Call objDatabase.Remove KillDatabase ============= Dim m_SQLServer As SQLDMO.SQLServer Set m_SQLServer = New SQLDMO.SQLServer m_SQLServer.LoginTimeout = 15 m_SQLServer.LoginSecure = False Call m_SQLServer.Connect("MyServer","sa","")) m_SQLServer.KillDatabase("MyDatabase") Call m_SQLServer.Disconnect