My 2007 post on Msg 1813, Could not open new database, is still popular. SQL Server expert Jeremy Roe sent an updated script for newer versions of SQL Server.
SQL SERVER – Error: Parameter ‘ProbePort’ does not exist on the cluster object. Unable to set Probe Port for Azure Load Balancer
Setting up an Always On listener with an Azure Load Balancer, I hit: Parameter ‘ProbePort’ does not exist on the cluster object. Here is what fixed it for me.
Diagnosing Blocking Chains With sys.dm_exec_requests
Trace blocking chains from active requests to a candidate head session, inspect sleeping transactions, and verify the owner before action.
SQL SERVER – xp_create_subdir() Returned Error 183, ‘Cannot Create a File When that File Already Exists
A client’s maintenance plan kept failing with: xp_create_subdir() returned error 183, Cannot create a file when that file already exists. Here is the fix.
SQL SERVER – Relating Unrelated Tables – A Question from Reader
A reader asked how to relate two unrelated tables, Table_A and Table_B, and show them in one output. Here is my answer to this unusual question.
How to Shrink All the Log Files for SQL Server? – Interview Question of the Week #203
Question: How to Shrink All the Log Files for SQL Server? Here is the script, plus why you should shrink only log files and never data files.
SQL SERVER – FIX: Msg 15281 – SQL Server Blocked Access to STATEMENT ‘OpenRowset/OpenDatasource’ of Component ‘Ad Hoc Distributed Queries’
Reading Excel, a reader got Msg 15281: SQL Server blocked access to STATEMENT ‘OpenRowset/OpenDatasource’. Enabling Ad Hoc Distributed Queries fixes it.