June 26, 2008 at 9:32 am
how to check which user deleted the stored procedures in sql 2000?
June 26, 2008 at 9:58 am
Did you have some sort of auditing or a profiler trace running at the time the objects were dropped? If not, you probably can't find who dropped them.
Greg
June 26, 2008 at 10:16 am
thanks greg
June 26, 2008 at 10:17 am
You could get a log reader and read through it. Log Rescue from Red Gate works on SS2K and it's free.
June 28, 2008 at 11:07 pm
[font="Verdana"]Hi Steve,
I had a doubt then, Suppose if the user drops SP @ 9:00 and full backup happens @ 10:00. Is it possible to read the tlog using 3rd party tool after 10:00 to find the user details??[/font]
Regards..Vidhya Sagar
SQL-Articles
June 29, 2008 at 10:21 am
Log backups have nothing to do with full backups. that is why you need to take log backups in addition to full backups.
If you are in simple mode, there's nothing that can be done, the log is truncated every few minutes. If you have the log (untruncated or backed up) and/or the log backups from 9:00am, you can read them.
June 29, 2008 at 11:19 am
vidhya sagar (6/28/2008)
[font="Verdana"]Hi Steve,I had a doubt then, Suppose if the user drops SP @ 9:00 and full backup happens @ 10:00. Is it possible to read the tlog using 3rd party tool after 10:00 to find the user details??[/font]
A full backup does not affect the transaction logs. Only transaction log backups affect the transaction log.
With that said, if you have regular transaction log backups - then you can easily use a log reader tool to read the transaction log backups.
If your database is in simple recovery model - then you probably won't be able to read the log.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply