Re: Audit on SQL 6.5
From: Neil Pike (neilpike_at_compuserve.com)
Date: 09/29/03
- Next message: Neil Pike: "Re: Security patch MS03-031 and Bug # 103075"
- Previous message: Neil Pike: "Re: Audit on SQL 6.5"
- In reply to: Ricardo: "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
- Next message: Neil Pike: "Re: Security patch MS03-031 and Bug # 103075"
- Previous message: Neil Pike: "Re: Audit on SQL 6.5"
- In reply to: Ricardo: "Audit on SQL 6.5"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
