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 |
|
harshal_in
Aged Yak Warrior
633 Posts |
 Posted - 2003-01-20 : 01:01:46
|
| Hi,I am trying to delete a database it gives me the following error:Server: Msg 3701, Level 11, State 8, Line 1Cannot drop the database 'cartcatalog1', because it does not exist in the system catalog.I can't even access any objects in the database it gives me the same error.any inputs?regards,harshal.Expect the UnExpectedEdited by - harshal_in on 01/20/2003 01:09:00 |
|
|
mohdowais
Sheikh of Yak Knowledge
1456 Posts |
Posted - 2003-01-20 : 02:01:09
|
| Hi harshalThe database might be having a "suspect" status. This usually occurs when the one of the database files has been corrupted, or there isnt enough free space on the server. If this is the case then try reseting the status of the db:sp_resetstatus 'DBName'OS |
 |
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2003-01-20 : 02:19:23
|
quote:
Hi harshalThe database might be having a "suspect" status. This usually occurs when the one of the database files has been corrupted, or there isnt enough free space on the server. If this is the case then try reseting the status of the db:sp_resetstatus 'DBName'OS
thankyou for the reply.But the status of the database was not suspect and the server is also having ample disk space.Actually we have an application which on installation creates an database and while testing this application we got this error after creating and deleting the same database for about 25 times.though the error got solved when I deleted the data files and log files manually and installed the application again .i.e. recreated the same database with the same name after deleting the existing data and log files.Are there any other resons for this error?thanks anyways.Regards,Harshal.Expect the UnExpected |
|
|
|
|
|
|
dropping database