Menu
I've connected to a few databases once and only once and will never need to again, however they clutter up the dropdown of logins available to select.
How can I reset the lists of servers and logins from the connection prompt in SQL Server Management Studio Express 2008?
414
asked Apr 01 '09 07:04
A login cannot be dropped while it is logged in. A login that owns any securable, server-level object, or SQL Server Agent job cannot be dropped. You can drop a login to which database users are mapped; however, this will create orphaned users.
You need to dynamically build a script that will do that.SELECT N'ALTER LOGIN ' + QUOTENAME(sp.name) + N' DISABLE;' FROM sys. server_principals sp WHERE sp.
In Windows 8/7/Vista: C:\Users\%username%\AppData\Roaming\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru. dat. Windows XP: C:\Documents and Settings\%username%\Application Data\Microsoft\Microsoft SQL Server\90\Tools\Shell\mru. dat.
In SSMS 2008, if you rename the SqlStudio.bin file to, say, SqlStudio.BAK, then SSMS will recreate this file upon re-opening the application. All servers and logins will be forgotten.
Reference
176
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
