I already have SP Creator that build Template for my tables operation but i think adding Code that handle event log every table without have Generic SP will make my...

Thanks Alot.

I almost finish my idea with handle it from another connection with using "READ_COMMITTED_SNAPSHOT" which "SSCrazy" Mention to, i will test it then i will decide.

I appreciate your help..

Thanks...

i was trying to simple the question from the begining, and i was 100% sure that can find answer here.

FYI i search alot before writing this question

anyway thanks for your...

i know old Data and New data. but i need to build one Stored procedure to handle any changes on data whatever was the table, with saving the changes into...

My idea is call SP that save old Data and new data in "Trace Log(Audit Trail)" table , this SP take parameters such as {Table Name, ID Of data}, so...

Yes i want to access data through same connection.

but i want to access Uncommited table data through another SQL Statement

begin TRAN

UPDATE Table1

SET Col1 = 10

WHERE Col1 = 1

{

SELECT *...

i try it, but it not work!!

Can you give me...