Results 1 to 3 of 3

Thread: OpenSchema perhaps?

  1. Jun 6th, 2000, 08:20 AM #1
    JasonGS
    JasonGS is offline

    Thread Starter
    Addicted Member JasonGS's Avatar
    Join Date
    May 2000
    Location
    California
    Posts
    155
    Does anyone know how to retrieve a list of who is currently connected to a SQL Server 7 database???
    Reply With Quote Reply With Quote
  2. Jun 6th, 2000, 11:58 AM #2
    Clunietp
    Clunietp is offline
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844
    Hi Jason

    Login to the MASTER database, and SELECT * FROM SYSUSERS

    Or you can peruse thru the SQL DMO object library to find it that way, but then you need the SQL server enterprise manager installed on your clients.....

    Tom
    Reply With Quote Reply With Quote
  3. Jun 6th, 2000, 01:05 PM #3
    Clunietp
    Clunietp is offline
    Guru Clunietp's Avatar
    Join Date
    Oct 1999
    Location
    USA
    Posts
    1,844
    My Bad!

    Use SELECT * FROM SYSPROCESSES

    SYSUSERS lists the users, not the active users

    SYSPROCESSES will list all processes from the system and active users

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width