Deleted database device.

[c4sob]

I have a database that I would like to drop but at some point the device for this database was physically deleted from the file system.
I've tried all sorts of things but it doesn't seem like Sybase will let me do anything with this database.
Is there a way to manually go in and delete this database?

--Charlie

 

[suchetan]

Hi,

You can use dbcc dbrepair(databasename,dropdb) to drop the database name.

 

[suchetan]

Hi,

You can use dbcc dbrepair(databasename,dropdb) to drop the database name.

Regards
suchetan