A short script to find a currently running query on your server using sys.dm_exec_requests, plus the KILL command to stop one that runs for too long.
SQL SERVER – 2008 – Change Color of Status Bar of SSMS Query Editor
Change the color of status bar in SSMS 2008 for each server, so a query meant for development never runs on production by mistake. Step by step with images.
SQL SERVER – Fix : Msg 15151, Level 16, State 1, Line 3 Cannot drop the login ‘test’, because it does not exist or you do not have permission
Msg 15151 said it cannot drop the login ‘test’, even for a sysadmin. The message was misleading: an open SSMS session for that login was blocking it.
SQL SERVER – Add Any User to SysAdmin Role – Add Users to System Roles
How to add any user to the SysAdmin role in SQL Server, with a short T-SQL script using sp_addsrvrolemember, or the same steps in Management Studio.
SQL SERVER – Fix : Error : Msg 15151, Level 16, State 1, Line 2 Cannot alter the login ‘sa’, because it does not exist or you do not have permission
Msg 15151, cannot alter the login ‘sa’, comes from missing rights. Only a member of the sysadmin role can change SA, so add the user to that role first.
SQL SERVER – DISABLE and ENABLE user SA
You cannot modify the permissions of the SA user, but you can disable and enable user SA with ALTER LOGIN. Log in with Windows authentication first.
SQL SERVER – Change Collation of Database Column – T-SQL Script
How to change collation of database column with ALTER TABLE ALTER COLUMN and COLLATE, then check it in sys.columns. A short test script shows each step.