SQL Server failed to start with Script level upgrade for database ‘master’ failed, CREATE SCHEMA failed due to previous errors. Here is why it happens.
SQL SERVER – Log Shipping Restore Job Error: The file is too recent to apply to the secondary database
Log shipping restore job failing because the file is too recent to apply to the secondary database? Here is what the LSN gap means and how to fix it.
SQL SERVER – Error Fix: Msg 300, VIEW SERVER STATE
Fix SQL Server Msg 300 when a user lacks VIEW SERVER STATE permission, and learn how to grant it safely without giving away too much access.
SQL SERVER – Linked server creation error: OLE DB provider “SQLNCLI11” for linked server returned message “Invalid authorization specification”
Creating a linked server between two local instances failed with OLE DB provider SQLNCLI11 returned Invalid authorization specification. Here is the fix.
Corrupted Model Database: How to Get SQL Server Running Again
SQL Server would not start due to a corrupted model database with error 5125. Here is how to restore a corrupted model database from backup the right way.
SQL SERVER – Failed Rule “Valid DSN” and “Valid Database compatibility level and successful connection”
Upgrading SQL Server 2016 CTP2.2 to CTP2.3, setup failed the rules Valid DSN and Valid Database compatibility level for Reporting Services. Here is what to check.
SQL SERVER – Scope of ERROR_MESSAGE
ERROR_MESSAGE() gives the exact error text inside a TRY CATCH block, but it returns nothing outside CATCH. A quick demo of the scope of ERROR_MESSAGE.