I deleted some databases but a service account keeps trying to access them. This is filling up my sql log file. I used profiler and got the names of the databases, but I do not know how to instruct sql or this service account to stop trying to access these databases. I checked if the deleted databases were still in some misc. table using the query below. They did not show up in the result set.
SELECT state_desc, user_access_desc, is_auto_close_on, is_in_standby FROM sys.databases WHERE name = N'deleted_database';
Thanks, Jon
Aucun commentaire:
Enregistrer un commentaire