Post reply

another question

  • January 18, 2012 at 12:16 am

    #253826

    i have 10 users ..

    they r connected to database...

    so i wanna check one user of the IP ADDRESS

    how to see..

    is there any command to see ..

  • January 18, 2012 at 12:43 am

    #1435005

    anilr71 (1/18/2012)

    i have 10 users ..

    they r connected to database...

    so i wanna check one user of the IP ADDRESS

    how to see..

    is there any command to see ..

    You can use one of the dm (sys.dm_exec_connections) to see the ipaddress of the process that is connected to db.

    Refer to the following link.

    http://msdn.microsoft.com/en-us/library/ms181509.aspx

    -- Babu

  • January 18, 2012 at 2:58 am

    #1435074

    thx babu

    have a nice day

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

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