I want certain steps to be taken in response to a user logout event, so I set up a trace in SQL Profiler that writes to a database table. On that table I created a trigger that fires ON INSERT.This works fine with SQL Server 2000, but with SQL Server 2008
the trace keeps crashing as soon as the first logout event occurs, i.e. the first row is inserted into the trace table.
Any ideas why? I would also be happy about a hint to another way of capturing and reacting to the logout event.
Many thanks in advance,
View Complete Post