Microsoft has released a hotfix for a problem that occurs because the start time for the Audit:Login Event is recorded as the time that the login succeeds. The start time for the Audit:Logout Event is recorded when the Process Status Structure (PSS) object is created. So when you view SQL Server Profiler in SQL Server 2000, the start times that are recorded in Profiler are different for the Audit:Login and Audit:Logout Events. You might also see transaction events in Profiler before the Audit:Login Event is recorded. To find out more about this problem and the supported hotfix, read the Microsoft article "FIX: Start times in the SQL Profiler are different for the Audit:Login and Audit:Logout Events in SQL Server 2000" at
Microsoft Fixes Profiler Event Bug in SQL Server 2000
0 comments
Hide comments