Post reply

How to find out the active connections

  • September 15, 2004 at 1:13 pm

    #86522

    we have 300 to 400 users connecting to sql server through our web server. How to find out names of active connections who is connected to the server.

    Thanks in advance

  • September 15, 2004 at 1:25 pm

    #523233

    exec sp_who

    Assuming they are connecting to SQL Server using their own usernames instead of a shared username/password.

    There are system tables, Enterprise Manager and other means of doing this as well.

  • September 16, 2004 at 3:30 am

    #523281

    you can also use the sql profiler

    Everything you can imagine is real.

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

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