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

[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

 

[Miha Markic]

Hi Steve,

Try with sp_who stored procedure.

 

[Miha Markic]

Or even better
exec sp_who 'active'
shall give you all acitve connections.