number of users connected

sundar k replied to Timothy Purvis at 04-Jul-08 11:57
You can execute sp_who or sp_who2 (system stored procedure in sqlserver) to find out the list of users connected to your sql server, you can execute this sp in your vb code and get the resultset and can find out who are all connected. Also, SQL Profiler Tool is useful if you need to track down a specific event, rather than get an overview.

Click here to sign in and reply. You could earn money via our $500 contest just for being helpful.
  Checdk To See If Someone Is Connected - Timothy Purvis  04-Jul-08 03:55 3:55:25 PM
      number of users connected - sundar k  04-Jul-08 11:57 11:57:55 PM
      Solution to To See If Someone Is Connected - Umapathy Kaliaperumal  05-Jul-08 03:02 3:02:45 AM
View Posts