Author: Pinal Dave

SQL SERVER – Error 17113, Severity: 16 – Error Occurred While Opening File ‘master.mdf’ to Obtain Configuration Information at Startup

SQL SERVER – Fix: Error 946, Severity: 14 – Cannot open database ‘DB’ version 782. Upgrade the database to the latest version

How to Keep Certain Records on Top While Ordering Data? – Interview Question of the Week #110

SQL SERVER – Cannot open backup device. Operating system error 1326 (Logon failure: unknown user name or bad password.)

SQL SERVER – FIX: Msg 7356, Level 16 – The OLE DB provider “ASEOLEDB” for linked server “SYBASESERVER” supplied inconsistent metadata for a column

SQL SERVER – FIX: Error 19456: None of the IP Addresses Configured for the Availability Group Listener can be Hosted by the Server

SQL SERVER – Migrating AlwaysOn Availability Group to New AD Domain

SQL SERVER – UpdateHADRResource – Failed to version-copy file – Exception data is: System.IO.IOException

SQL SERVER Management Studio – Exception of type ‘System.OutOfMemoryException’ was thrown. (mscorlib)

SQL SERVER – Puzzle – Why does sp_spaceused Show No Values?

SQL SERVER – The header for file Path is not a valid database file header. The PageAudit property is incorrect