Skip navigation

Null Characters Can Mask Login Names in Microsoft SQL Profiler

SQL Profiler, included with Microsoft SQL Server, is commonly used to audit connections to the server. However, Imperva Inc. discovered that login names prefixed with null characters aren't visible to the profiling tool in SQL Server 2000. Microsoft said that the problem is fixed in SQL Server 2005.

The Microsoft article "BUG: Login names that contain leading zero characters are not visible when you use SQL Profiler to audit connections to SQL Server 2000" explains that the problem also exists when using certain stored procedures to monitor connections. The article also offers workaround information.

TAGS: Security
Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.