Error 21776

[dba123123]

I was trying to delete the Database "MQIS" in SQL server 7 through enterprise manager and received the error as

"error 21776: [SQL-DMO} the name "MQIS" was not found in the database collection. if the name is a qualified name, use [] to seperate the various parts and try again"

This database has been suspect. I tried to create a new database with the same and will not overwrite the old one.

Any suggestion or help will be appreciated.

Laura

 

[codestorm]

Given the error, are you sure you're logged in as someone with permissions to see that DB when attempting to delete it? <insert witticism here>
codestorm

 

[Spellman]

Hi Laura,

You could try using the Drop statement in the query anylyser and say

Drop Table MQIS