Msg 4621 says permissions at the server scope can only be granted when the current database is master. Switch to master with USE master and grant again.
SQL SERVER – 2008 – SCOPE_IDENTITY Bug with Multi Processor Parallel Plan and Solution
SCOPE_IDENTITY can return a wrong value when a query uses a parallel plan on a multi processor server. Run it on one processor or, better, use the OUTPUT clause.
SQL SERVER – 2008 – Activity Monitor is Empty – Fix Activity Monitor for All Users
In SQL Server 2008, Activity Monitor is empty for a user without the right permissions. Here is how to fix Activity Monitor for all users.
SQL SERVER – FIX : ERROR : Msg 5834, Level 16, State 1, Line 1 The affinity mask specified conflicts with the IO affinity mask specified. Use the override option to force this configuration
Msg 5834 says the affinity mask conflicts with the IO affinity mask when you change fill factor with sp_configure. The fix is RECONFIGURE WITH OVERRIDE.
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.