Home Forums SQL Server 2005 Administering GET the windows or Operating System loginname using sql server 2005 RE: GET the windows or Operating System loginname using sql server 2005

  • dakshinamurthy-655138 (4/19/2010)


    No,

    my Pc or Laptop loginname is dakshina, where as i login to sql server using sa login and its password, the sql server may be either in my own pc or laptop or it might be in a different system or server .

    With Regards

    Dakshina Murthy

    Then you are out of luck. SQL Server has no way of determining who is logged in to a particular PC or Laptop directly. You may be able to write something using PowerShell that could possibly use WMI to query back to the PC or Laptop to determine who is logged in, but that is out of my current scope of knowledge.