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 |
|
hanifikri
Starting Member
14 Posts |
 Posted - 2007-05-09 : 22:13:27
|
| Hi,I need to drop testing database in testing server. This database data files has been deleted. Now the database in no longer exist in sysdatabases.When i want to drop this database it give me an error saying that this database is not exist.How do i drop this database? Please advise.Thanks. |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-05-09 : 22:57:18
|
| If the database files don not exist, and there is no entry is sysdatabases, then you have already dropped it.CODO ERGO SUM |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-05-10 : 05:37:57
|
| <<How do i drop this database? Please advise.>>How can you drop a database that didnt exist?MadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Drop Database