Link to home
Start Free TrialLog in
Avatar of kasiencja
kasiencjaFlag for Canada

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
Avatar of Aneesh
Aneesh
Flag of Canada image

Hello kasiencja,

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
Avatar of Allister_Reid
Allister_Reid

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
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kasiencja

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
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
that makes sense :) in future make sure that you clearly specify the requirements