Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How Can I ??

Status
Not open for further replies.

Uriel365

Programmer
Dec 18, 2001
37
GB
I have been asked because of the new lisencing requirements to find out if it is possible to use VB6 to ascertain who is currently logged into an SQL 2000 database. Any help or nudge in the right direction would be greatly appreciated.

Paul
 
You can read up on sp_who

Provides information about current Microsoft® SQL Server™ users and processes. The information returned can be filtered to return only those processes that are not idle.

[flowerface]

"All I ask is the chance to prove that money can't make me happy." - Spike Milligan
 
Or just read the replies in your other thread !!!!!
thread183-661576
[elephant2]

"All I ask is the chance to prove that money can't make me happy." - Spike Milligan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top