Detect overlapping date ranges with joins and window queries, use half-open endpoints, and enforce the rule with a multirow trigger.
SQL SERVER – Fix : Error : 17892 Logon failed for login due to trigger execution. Changed database context to ‘master’.
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.
SQL SERVER – Interesting Observation of Logon Trigger On All Servers
I created a Logon Trigger to audit every successful login for a client, and one login was recorded several times on different threads. The script and what I saw.
SQL SERVER – Guidelines and Coding Standards Complete List Download
My coding standards complete list for SQL Server, cut to what people follow: naming, formatting, and the rules that prevent real bugs.
SQL SERVER – 2008 Interview Questions and Answers – Part 1
Part 1 of my SQL Server 2008 interview questions and answers covers general questions like what is RDBMS and the properties of relational tables.
SQL SERVER – Disable All the Trigger of Current Database
Another way to disable all the trigger objects in the current database: a stored procedure by Manish Kaushik that loops over each table and disables them.