Deletinga a database caused problems...why?

[happyb]

Hi,

I recently wanted to clear up some space on my MSSQL 7 Server so I deleted some unwanted databases. I used enterprise manager and right clicked on the database that I wanted gone and chose delete... pretty simple hey?

Now, since I have done that I cannot use the enterprise manager, everytime I try to open it I get a Dr Watson error. When I look in the event viewer there are two errors. One is EventID 4079 - application error exe/mmc.dbg and the other error which I am not sure of the ID but it was trying to open a stored procedure called sp_xmail or something like that.

Any Ideas? Did I forget to do something before deleting? If this is the case anyone know of a workaround? I have been on the Microsoft Site, and nothing helps.


Thanks for any ideas... I promise that I will learn my lesson the first time

 

[foxdev]

Is your problem using EM only on one client PC, all client PCs, or the server?

If its on the client PC, I'd suggest re-installing the SQLS client tools.
Robert Bradley

http://www.foxdev.com/

http://www.agrainofhope.org

 

[TomSark]

After deleting the databases, did you back up master? Is it possible that an older backup of the master database was restored on this server? Tom Davis
tdavis@sark.com

http://www.sarkdallas.com

 

[happyb]

The EM is on the SQL server not the client machine, and yes I think that the master was backed up. I have set all databases to be backed up every 24 hours.

Emma