Results 1 to 2 of 2

Thread: login Trace

  1. #1
    Join Date
    Nov 2003
    Posts
    9

    Unanswered: login Trace

    Hi,
    How to know in ASE 11.5.1 , how many users are connecting during a period

    in ASE 12.5, there the "login trigger", but in 11.5, is there a way to know
    how many users are login into the database without using the sp_who command

    Thanks

  2. #2
    Join Date
    Jun 2002
    Location
    Argentina
    Posts
    78
    It's not a great thing but you can make selects of the "master..sysprocesses"

    select db_name(dbid) db,
    count(*) total
    from master..sysprocesses
    where suid <> 0
    group by db_name(dbid)
    order by db_name(dbid)
    compute sum(count(*))
    go

    The "login trigger" is a better solution but only in 12.5 or higher.
    Bye bye,

    Sebastian

Posting Permissions

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