Prepare a Microsoft support case with version details, a clear timeline, error logs, system_health, dumps, LogScout, and redaction notes.
SQL SERVER – SSMS Query Command(s) completed successfully without ANY Results
A friend’s SSMS window returned only Command(s) completed successfully for every query. I logged in remotely and found what was wrong with that session.
SQL SERVER – The server network address “TCP://SQLServer:5023” can not be reached or does not exist. Check the network address name and that the ports for the local and remote endpoints are operational. (Microsoft SQL Server, Error: 1418)
Error 1418 in database mirroring says the server network address cannot be reached. Try my suggestions one by one, starting with a NO RECOVERY restore.
SQL SERVER – Fix: Error: 262 : SHOWPLAN permission denied in database
My students got Msg 262, SHOWPLAN permission denied, when they tried to view an execution plan. One GRANT SHOWPLAN statement fixes it.
SQL SERVER – Unique Nonclustered Index Creation with IGNORE_DUP_KEY = ON
What does IGNORE_DUP_KEY = ON do on a unique nonclustered index? Duplicate inserts give a warning instead of an error, and my example shows both options.
SQL SERVER – FIX: Error: 1807 Could not obtain exclusive lock on database ‘model’. Retry the operation later.
Error 1807 says SQL Server could not obtain an exclusive lock on database ‘model’ during CREATE DATABASE. The fix that worked for me takes seconds.
SQL SERVER – Fix Error 1949, Level 16: Cannot create index on view. The function yields nondeterministic results
Fix Error 1949: cannot create index on view because a function yields nondeterministic results. A training attendee hit it; removing that function solved it.