Post reply

how to get list clients that connected to sql server over the network?

  • January 29, 2012 at 5:01 am

    #255570

    hi all

    can you help me?plz

    i work with sql server 2008

  • January 29, 2012 at 5:10 am

    #1439722

    tnt750 (1/29/2012)

    hi all

    can you help me?plz

    i work with sql server 2008

    Many people here will attempt to assist you.

    But what is your problem ... ? ? ? ? ?

    Is it login auditing if so please read:

    How to: Configure Login Auditing

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

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • January 29, 2012 at 5:27 am

    #1439724

    Check who all connected.

    exec sp_who

  • January 29, 2012 at 9:41 am

    #1439749

    You could also use the Activity Monitor. Just Right Click the SQL Instance and choose Activity Monitor. Then choose Processes. It will list who is connected and to what Database, what workstation name they connected from, current command they ran like a select statement.

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

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