Chose Evaluation Edition in a hurry and now the evaluation period has expired? Here is how to activate SQL Server by moving to a licensed edition.
SQL SERVER – Startup Problem – FIX – Error 5118, Severity 16, State 1
The SQL Server service would not start for a DBA fresh out of college. The cause was Error 5118, and here is how to read it and fix it.
SQL SERVER – Login failed for User ‘NT AUTHORITY\ANONYMOUS LOGON’ – ERRORLOG
A reader’s event log and ERRORLOG filled up with Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Here is why it happens and how SPN errors are involved.
SQL SERVER – FIX: Msg 3102, Level 16, State 1 – RESTORE cannot process database ‘Name’ because it is in use by this session
Msg 3102 says RESTORE cannot process the database because it is in use by this session. The fix is simple: switch to master before you restore.
SQL SERVER – FIX – Error 3702, Level 16, State 3 – Cannot Drop Database “DB_Name” Because it is Currently in Use
Error 3702 says you cannot drop the database because it is currently in use, and even speakers get stuck on it. Here are simple ways to get past it.
SQL SERVER – Errors and Limitations of Working with SPARSE Columns in SQL Server
What is the catch with SPARSE columns? After a question at SQLBangalore UG, here are the errors and limitations of working with SPARSE columns.
SQL SERVER – Restore Error: Specified cast is not valid (SqlManagerUI)
Restoring a SQL Server 2008 R2 backup failed with Specified cast is not valid (SqlManagerUI). Here is what we found after a few emails and screenshots.