Post reply

SQL2005 PROFILER

  • October 1, 2009 at 2:54 am

    #205225

    Dear Sir/ Madam,

    In SQL 2005, we can not find any information from profiler. Cause field “NTUserName” almost empty.

    File is attached for referance.

    Your help in this regard will be highly appriciated.

    Thanks

    Adeel Imtiaz

  • October 1, 2009 at 4:15 am

    #1060356

    SQL Server Supports two types of Authentication one is SQL server Authentication and another is windows integrated authentication. The Blank columns in NT User name means those are the sessions connected to SQL Server using a SQL server Authentication and in that case you can see the Sql server user name in the next column 'Login Name'. for getting the info on connected users, You can use the sp_who and sp_who2 systems stored procedures too..

    ..

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply