Post reply

SQL Server Log

  • 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

  • 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

  • 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.

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

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