kasiencja
asked on
Is there something similar to Diff for SQL Server 2008
Hi,
I have a huge database and an even bigger spaghetti code that I'm supposed to learn. I was wondering if there is some kind of a tool or a way to see what tables were affected and what was changed after a user action.
Thanks,
Kathryn
I have a huge database and an even bigger spaghetti code that I'm supposed to learn. I was wondering if there is some kind of a tool or a way to see what tables were affected and what was changed after a user action.
Thanks,
Kathryn
You may also consider looking at SQL Server Profiler, with some configuration this will show what queries are running and the associated parameter values.
Regards
Regards
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I've also just installed a package from Redgate, which looks quite promising. It compares databases including data changes. Testing it now.
i dont really understand the question, i thought your intention was to learn the code and i think i did answer the question, correct me if i am wrong
ASKER
I'm sorry if I didn't make the question clear. What I wanted to find out was if there is a way to compare before and after database snapshots. After would be when a user action happens, this way I can easily figure out which tables are used where, instead of going through thousands of lines of code.
Regards,
Kasia
Regards,
Kasia
that makes sense :) in future make sure that you clearly specify the requirements
you can debug the code, that will give you an idea of whats happening during the execution, eventhough it didnt give you the contents you are inserting (unless u have a select statement after the insert ). it will be pretty handy
Regards,
Aneesh