Article ID: 253274
Article Last Modified on 10/17/2003
APPLIES TO
- Microsoft SQL Server 7.0 Standard Edition
- Microsoft SQL Server 2000 Standard Edition
This article was previously published under Q253274
BUG #: 57424 (SQLBUG_70)
SYMPTOMS
In SQL Server 7.0 Books Online, example E, Configure SQL Server to Automatically Audit All Sessions at Disconnect, in the xp_sqltrace (T-SQL) topic, shows how to set xp_sqltrace as a startup stored procedure. However, this example does not work as documented.
If you use the example, the audit trace does not start, and the following errors appear in the Windows NT Application Event Log:
WORKAROUND
To work around this problem, create a trace queue and use xp_trace_setqueueautostart to make the queue automatically start on the server's next restart. For an example, see the xp_trace_setqueueautostart (T-SQL) topic in the SQL Server 7.0 Books Online.
STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Keywords: kbbug kbpending KB253274