Article ID: 910741 - View products that this article applies to.
Bug #: 297092 (SQLBUDT)
Acknowledgment: Amichai Shulman of Imperva Inc. contributed to this Microsoft Knowledge Base article.
When you use SQL Profiler in Microsoft SQL Server 2000 to audit connections to SQL Server 2000 by using the Audit Login event class, login names that contain leading zero characters are not visible in the following contexts:
Additionally, you experience the same problem when you use the following methods to audit connections to SQL Server 2000:
We recommend that you audit connections to SQL Server 2000 by using server-side tracing and by loading the resulting data from a server-side trace file into a database table. To do this, use the fn_trace_gettable function.
For more information about the fn_trace_gettable function, visit the following Microsoft Developer Network (MSDN) Web site:
Article ID: 910741 - Last Review: November 2, 2007 - Revision: 2.7
Contact us for more help
Connect with Answer Desk for expert help.