Hi Diane,

We use Log Explorer. Our transaction log gets backed up every hour contiguously but we clear the log at 1am every morning (after we run a full backup)....

Cheers for the script, we'd actually already got the new table and trigger created by the time you'd posted!! Works like a dream.

I appreciate the help.

Matt.

thanks for the response guys.

I agree that profiler is the way to go most of the time. Unfortunately in this scenario I'm trying to capture a bulk delete statement...

Hey Brian,

Yup, I moved the order by clause outside of the parentheses to no avail. Even if I remove the order by completely it now gives an error:

Line 8:...

Hi Andy,

BOL has the following info on TOP:

SELECT [ ALL | DISTINCT ]

[ { TOP integer | TOP integer PERCENT }...

Further to the above post, is their a simple query to run that will give you a list of all records in a table EXCLUDING duplicates? I want to...

Thanks for your help guys, problem solved!