Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 get from log files

Author  Topic 

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2008-04-15 : 02:07:05
yesterday - i messed up a stored procedure for about an hour ---
in the meantime i had a program posting to the stored procedure without proper error handling.

is there anyway of getting from the log files these exec to this specific stored procedure so i can rerun them now that they would work?

tosscrosby
Aged Yak Warrior

676 Posts

Posted - 2008-04-15 : 10:50:39
Search on Google for transaction log readers. I know I found one at Apex that I used to view a log and answer some concerns we were having (it was a demo version so I didn't have full functionality). Nothing that I'm aware of within SQL, however.

Terry
Go to Top of Page

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-04-15 : 22:57:09
Or Log Explorer from Lumigent.
Go to Top of Page
   

- Advertisement -