Listing 'active' users connected to a SQL Server database.

  • Thread starter Thread starter Steve Randall
  • Start date Start date
S

Steve Randall

I'm sure this has been done before but I can't seem to
locate anything on this subject so...

I am looking to write a management component using VB.NET
and ADO.NET that returns a list of the 'active' users
against a specific named database in SQL Server 2000. The
key point here is 'active' users.

Has anyone done this before, or have any pointers as to
where I can find out more info on this.
Many thanks.

Steve
 
Or even better
exec sp_who 'active'
shall give you all acitve connections.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

What are the steps to fix damaged MDF files in SQL Server? 0
SQL Server 2000 9
SQL Server 2005 installation 3
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Sql Server Express won't let me connect 8
SQL Questions: Attaching Databases to SQL Server 4
Problem connecting to SQL Server 2000 9
Database connection issue using SQL schema user account 3

Back
Top