Tsql for Login and logout details of sql logins in mssql2000

• sameer_bhagat_1

  SSC Veteran

  Points: 280

  More actions

  January 14, 2009 at 4:06 am

  #77174

  Hi,

  Can any bodyhelp me? I need a Tsql which gives the details of Login and Logout of MSSQL2000 users other than running trace for it or enabling C2 configuration option.

  I need the same to review for how much time and how many times the particular user has been logging in/out on SQL server.

• Old McDonald

  SSCertifiable

  Points: 5768

  More actions

  January 14, 2009 at 4:37 am

  #926463

  Are you also known as hemant789 who posted the same question (word to word) in the following post:

  http://www.sqlservercentral.com/Forums/Topic636110-8-1.aspx

  :hehe:

  -Vikas Bindra

• sameer_bhagat_1

  SSC Veteran

  Points: 280

  More actions

  January 14, 2009 at 11:18 pm

  #927082

  Thanks Vikas for the replay.

  No I am not Hemant, but he is my friend.

  I have gone thr. replay to Hemant on same topic.

  The option you have suggested is to use trace only, but I don't want to use trace.

  Please suggest the option other than trace.

  Thanks & Regards,

  Sameer D. Bhagat