SQL Server Log

• Kashif

  SSCommitted

  Points: 1881

  More actions

  November 26, 2001 at 3:35 am

  #57827

  Hi all

  Can anyone please tell me What and How information can be extracted from SQL Server Log?

  Regards,

  Kashif

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  November 26, 2001 at 4:59 am

  #420379

  Depends on what you mean. Officially, the only thing you can do is backup or restore, SQL provides no built in means to edit or view the logs. A good thing in general. There is a 3rd party product called Log Explorer that lets you view and edit a log file.

  Andy

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• Kashif

  SSCommitted

  Points: 1881

  More actions

  November 26, 2001 at 11:57 am

  #420390

  Thanks Andy. I have just used its latest version. The only thing bothers me is that it is capable of tracking NTHostName and UserName but by adding a table name 'Lugiment_Profiler' to your selected database and then probably adding a trigger that fires at every transaction, which is performance costly for database I am working with.

  Thanks again.