Dropped the database your logon trigger writes to? Every login then fails with Error 17892 Logon failed. I recreate the problem and show how to get back in.
SQL SERVER – Interesting Observation of Logon Trigger On All Servers – Solution
Why does a logon trigger on all servers fire several times for one login? The answer: several SQL Server services are running and IntelliSense is on.
Stopping Backup Success Messages From Flooding the Error Log
Reduce backup success messages in the SQL Server error log with trace flag 3226, verify msdb history, and cycle logs safely.
Hunting Suspicious Objects After a SQL Server Compromise
Investigate a SQL Server compromise by preserving evidence and checking logins, startup procedures, Agent jobs, risky features, and changed objects.
SQL SERVER – Delete Duplicate Rows
Delete Duplicate Rows quickly with a CTE and ROW_NUMBER() in SQL Server 2005 and 2008. A sample table with 7 rows, 3 of them duplicates, shows how it works.
SQLAuthority News – TechEd on Road Ahmedabad June 20, 2009 – An Astounding Success
My recap of TechEd on Road Ahmedabad on June 20, 2009: 200+ attendees, people traveling from all over India, and two back to back SQL sessions.
A Health Check for an Inherited Server
A health check for an inherited server reviews backups, access, configuration, error logs, and jobs before anyone changes the system.