September 22, 2003 at 9:31 am
Hello,
How can i find out who has changed the datas from a table, if at least i can find from which machine then that will be of great help.
Thanks in advance
September 22, 2003 at 2:33 pm
You can use a third party tool like Lumigent log explorer to read the logs or use Lumigent Entegra for a more fully auditing tool. If you don't want to purchase software you could use hostname() and susersname() in triggers to capture this information.
HTH
Ray Higdon MCSE, MCDBA, CCNA
------------
Ray Higdon MCSE, MCDBA, CCNA
September 22, 2003 at 3:01 pm
Lumigent is really your only option, but if you only need to "read" the log, then there is a lower priced version I beleive.
Steve Jones
http://www.sqlservercentral.com/columnists/sjones
The Best of SQL Server Central.com 2002 - http://www.sqlservercentral.com/bestof/
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply