Cannot shrink log file because the total number of logical log files cannot be fewer than 2. Here is what the message means.
SQL SERVER – Information Message: Cannot shrink file in database to xxxx pages as it only contains yyyy pages.
A reader hardcoded 1 GB in my log shrink script and got: Cannot shrink file in database to xxxx pages as it only contains yyyy pages. I explain why it appears.
How to Create an Empty Table and Fool Optimizer to Believe It Contains Data? – Interview Question of the Week #204
How do you create an empty table and fool the optimizer into thinking it has data? Nobody asked me that in 20 years, but I use this trick in Health Checks.
SQL SERVER – FIX: Msg 15190 – There are still remote logins or linked logins for the server
Dropping a linked server with sp_dropserver failed with Msg 15190: There are still remote logins or linked logins for the server. Here is how to clear them.
SQL SERVER – Fix : Error Msg 1813, Level 16, State 2, Line 1 Could not open new database databasename. CREATE DATABASE is aborted
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 – 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.