Restoring a SQL Server 2016 backup on a 2014 instance fails with Error 3169, backed up on a server running a newer version. Here is why and what you can do.
SQL SERVER – SSMA Error : System.Data.OracleClient requires Oracle client software version 8.1.7 or greater
I said I have no clue as to why this is happening and I asked if it was in any way related to SQL Server? Let us fix SSMA Error.
Tracking sp_configure Changes Through Error Log Messages
Someone changed a setting and nobody admits it. Here is what the SQL Server error log keeps, and what it never records.
SQL SERVER – FIX: sp_rename error Msg 15225 – No item by the name of ‘%s’ could be found in the current database
Msg 15225 is a common sp_rename error: No item by the name could be found in the current database. Here is why it happens and the fix.
SQL SERVER – FIX: SQLServerAgent is not currently running so it cannot be notified of this action. (Microsoft SQL Server, Error: 22022)
Error 22022 says SQLServerAgent is not currently running so it cannot be notified of this action. Here is what causes it and how to fix it.
SQL SERVER – Unable to drop login – Msg 15170, Level 16, State 1
Cleaning up my demo server, I could not drop login danny because of Msg 15170: the login owns a job. Here is how to find what a login owns and remove it.
SQL SERVER – Error and Fix for Msg 1907 Cannot recreate index The new index definition does not match the constraint being enforced by the existing index
Moving to a Clustered ColumnStore Index can throw Msg 1907: cannot recreate index, as the new definition does not match the constraint. Here is why and the fix.