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 .




    Tuesday, January 29, 2008 10:40 AM

All replies

  • Hi,


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




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

    Can any one help me on this.


    Moderator please help me in getting this resolved.





    Thursday, January 31, 2008 10:42 PM