November 26, 2001 at 3:35 am
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
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
November 26, 2001 at 11:57 am
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