Table changes
-
Hi everyone.
Anyone offer some advice on a script or proceedure I can run that will detect a change to a set of tables.
In outline what happens is that a management task is run from within an application ( application that has been inheritated ) that deletes\ moves 6 months worth of data.
I want to understand what tables are effected by doing this ?
Could possibly run an SP , but there are loads listed and I wound'nt know where to start looking.
Appreciate any advice.
Cheers
-
#1. Do you know when it's schedule is?
#2. Do you have the source code to see what it does?
#3. Fire up Profiler to capture the traces....
Good Hunting!AJ Ahrens
webmaster@kritter.net -
Thanks for this , in reply.
1. We manually run the maintenance task .
2, No source code.
3. Ok will try to run profiler next time running the task.
I was looking to see if there was any kind of system table that would record when a user table is amended , so we could see the deletions and that way work out what table is effected.
-
El,
Unless you have auditing enabled (created by you to track changes) then unfortunately, there is no audit trail.
Sorry
Good Hunting!AJ Ahrens
webmaster@kritter.net
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply