Hi Bhuvanesh,

here i am loging to SQL Server after loging to my desktop or Laptop PC , now i would like to track the login name which i use to login to the lap top where i have SQL Server 2005 and from there i will connect to my Destination DB.

When i execute the query you gave i will get the information as follows

name sid

sa 0x01

and so on.

With Regards

Dakshina Murthy