Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Posts
    29

    Unanswered: User login time.....

    Hi all,

    I am using ASE 12. A user logged in to the database and not yet logged out. Is there any way I can find out the when he logged in?

    Thanks

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    Well.... sp_reportstats is supposed to show this information, but there has been a long standing bug that does not updat ethe accdate in syslogins upon flushing.

    Check with Sybase support if there is a fix or workaround and let us know here.

    1> sp_reportstats 'sa'
    2> go
    Name Since CPU Percent CPU I/O
    Percent I/O
    ------------------------------ ----------- ----------- ----------- -----------
    -----------
    sa Feb 10 2003 0 0.0000% 0
    0.0000%

    (1 row affected)

    Total CPU Total I/O
    --------------- ---------------
    543.0 3995.0

    (1 row affected)
    (return status = 0)
    1>

Posting Permissions

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