Post reply

where can i get login logout tmming of database user in MS-SQL SERVER

  • May 19, 2004 at 2:55 am

    #85113

    Our client requiry login logout timming of a datase user that where can get

  • May 19, 2004 at 4:00 am

    #506911

    You cannot unless you are using Profiler to monitor connections or you turn Auditing on in the Server Properties under the Security tab in EM.

  • May 20, 2004 at 8:55 pm

    #507215

    Auditing All from Server Properties under the security tab will give you login info but I don't think it would give logout info.

    You can use c2 to capture but please be aware that c2 configuration option audits everything and hence will have a performance overhead. You can write your own trace using sp_trace* stored procs to audit only login logout events and make your trace as a stored proc and mark it as a startup proc.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply