locked
unforeseen doings of SQLServer2005 Security Table RRS feed

  • Question

  • Hi,

     

    While working with security feature of SQLServer2005 i came across a unforeseen doing of SQLServer2005 Connection table.

    On executing the Query

     

    select login_name,host_name,program_name from sys.dm_exec_sessions where session_id>25

     

    I see a record with no hostname and Program name bu ti see login name.Now i dont know who is connected and from which machine and Program.

     

     

    login_name                    login_time                               host_name       program_name

    CORP\Mohd2_22717   2008-01-09 00:43:56.933

     

     

    Please help me in knowing why SQLServer2005 behaves in such ways.

    As from SOX prospective i am not able to justify the auditor what exacly it is .

     

    Regards

    Sufian

    Tuesday, January 29, 2008 10:40 AM

All replies

  • Hi,

     

    Is this a BUG.If so please report the same to Microsoft.

     

    Regards

    Sufian

    Wednesday, January 30, 2008 2:36 PM
  • Hi,

    Can any one help me on this.

     

    Moderator please help me in getting this resolved.

     

    Regards

    sufian

     

    Thursday, January 31, 2008 10:42 PM