SQL Server Express 2008- Determine which rows were changed added after operation

thready
thready used Ask the Experts™
on
Hi Experts,

I'm trying to find all the changes made to a database after I do something in the UI.  I'm interested in seeing the affected rows.

What's the best way to do this?

Many thanks!
Mike
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike EghtebasDatabase and Application Developer
Commented:
Add a timestamp column to your table.

"timestamp is a  data type that exposes automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes." see https://technet.microsoft.com/en-us/library/Aa260631(v=SQL.80).aspx
Problem resolver
Commented:
Hi,
You can create Update trigger on the table, to record any changes ever made to the table.

Author

Commented:
Thanks!  :)

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial