jeudi 1 janvier 2015

Error 18456 State 38 on Deleted Databases


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