Re: Audit on SQL 6.5
From: Neil Pike (neilpike_at_compuserve.com)
Date: 09/29/03
- Previous message: Mirta: "FWD: Check out the pack from the MS"
- In reply to: Ricardo: "Audit on SQL 6.5"
- Next in thread: Sue Hoegemeier: "Re: Audit on SQL 6.5"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 29 Sep 2003 18:44:47 +0100
Ricardo,
Unless you've got triggers defined that are logging the info then you're
probably going to be out of luck. If you do happen to have the old transaction
log file from when the update was made you may be able to get info out of it if
you save it away somewhere.
You can try old log viewing tools from www.dbsg.com, the dbcc page/log
commands. The best tranlog tool is www.lumigent.com, but that's probably SQL 7
minimum.
> I´m triying to find who made an update to my databases,
> do you know how can i do it, i´m using SQL 6.5 and Win NT.
>
> Thanks
>
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforums/UK/default.asp?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq
- Previous message: Mirta: "FWD: Check out the pack from the MS"
- In reply to: Ricardo: "Audit on SQL 6.5"
- Next in thread: Sue Hoegemeier: "Re: Audit on SQL 6.5"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
