Display users logged on in the current session
Author: Chandra Sekhar Ananthapatnayakuni
Rating: Rate this Resource
Visits: 6296

Discuss in Newsgroups

SELECT Loginame,spid,db_name(dbid)
FROM master..sysprocesses
WHERE db_name(dbid)='dbname'

Visit my guru profile

Visitor Comments

Be the first to rate this code sample!

Rate this Code Sample