Interview Questions and Answers Part 4 begins with SQL Profiler: what it is, how it captures events to a file or table, and how to keep traces small.
SQL Server Interview Questions and Answers Introduction
Interview Questions and Answers Introduction: why I started this six part series after many reader requests. The updated questions now live at a new location.
SQL SERVER – Fix: Server: Msg 7391, Level 16, State 1, Line 1
Msg 7391 has no single fix. I list the causes I have hit on my servers, from distributed transactions on linked servers to DTC firewall settings, to try one by one.
Checking the Update History of an Instance
Reconstruct SQL Server update history from Setup Bootstrap logs, startup error logs, and the current build when no patch ledger exists.
SQL SERVER – FIX : Error 15023: User already exists in current database.
Error 15023: User already exists in current database. I fix it with sp_change_users_login, using Report, Auto_Fix or Update_One to link the user to a login.