Sample Header Ad - 728x90

How to remove remaining traces of a detached database from a server?

0 votes
1 answer
74 views
I had a database Coderr that I no longer wanted. Unfortunately, I detached it instead of dropping it. Now I'm seeing traces of it pop up in SSMS dialogs: enter image description here I'd like to remove this (and any others that may be lurking). I tried DROP DATABASE [Coderr], but I got this error: > Cannot drop the database 'coderr', because it does not exist or you do not have permission I found this Q&A , but the T-SQL over there is a bit over my head and I'm nervous running it since I don't know whether it applies to my scenario. How can I permanently clean all references to this old, unwanted database from my server? Will it be possible to do so, or am I stuck with the consequences of my goof-up?
Asked by InteXX (559 rep)
Jan 29, 2023, 12:10 AM
Last activity: Jan 29, 2023, 11:23 AM