Hi all,
Need ideas on this.
Tried to drop a database and got the following error message
12:31:50 PM DBMS intrade_prod -- Attempt to locate entry in sysdatabases for database 'intrade_fantasy_oltp' by name failed - no entry found under that name. Make sure that name is entered properly.
here is the data from the sysdatabases table
name dbid suid status version logptr crdate dumptrdate status2 intrade_fantasy_oltp 20 10 4 1 1357087 1/4/2002 2:48:04 PM 2/1/2004 12:01:09 AM -32768 0 0 0 0 [NULL] [NULL] 4 0
so then i mark the database as suspect (change status to 320)
and then do a dbcc dbrepair(intrade_fantasy_db,dropdb)
i get the same error message as above.
I can't drop the database
I see my only option now is to recycle the sybase server.
Has anyone seen this before or have any ideas
Thanks,
Dave
Need ideas on this.
Tried to drop a database and got the following error message
12:31:50 PM DBMS intrade_prod -- Attempt to locate entry in sysdatabases for database 'intrade_fantasy_oltp' by name failed - no entry found under that name. Make sure that name is entered properly.
here is the data from the sysdatabases table
name dbid suid status version logptr crdate dumptrdate status2 intrade_fantasy_oltp 20 10 4 1 1357087 1/4/2002 2:48:04 PM 2/1/2004 12:01:09 AM -32768 0 0 0 0 [NULL] [NULL] 4 0
so then i mark the database as suspect (change status to 320)
and then do a dbcc dbrepair(intrade_fantasy_db,dropdb)
i get the same error message as above.
I can't drop the database
I see my only option now is to recycle the sybase server.
Has anyone seen this before or have any ideas
Thanks,
Dave