I want to remove the database reference from the master database after the physical database files got deleted from windows explorer
the smo statements I use are the following
the error message that I get states:
- kill database failed
- unable to find the physical file at location XXXX
Is there a stored procedure that I can use that solves this problem
You can drop the database using T-SQL:
DROP DATABASE MyBadDatabase;
thanks DROP worked.
I thought that KILL was the more resilient or mean version of delete database
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?