Tag Info

New answers tagged


Sure, here are the commands listed below. (Reformatted from original post for reading ease.) These can derived from clicking on Server Properties, then choosing the Security tab and changing the Login auditing settings and scripting out the code, instead of clicking on the OK button to close the dialog. This type of scripting is usually an option on ...


In SSMS 2008, I believe you need to delete the file C:\Users\%username%\AppData\Roaming\Microsoft\SQL Server Management Studio\%Version%\SqlStudio.bin This will, however, clear ALL of the logins and saved servers. You may be able to edit the file using an editor, but I believe it would just be easier to start from scratch. If you are using SSMS 2012 or ...

Top 50 recent answers are included