Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
To create History table to record changes in fields
Message
From
12/07/2006 17:01:46
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
To create History table to record changes in fields
Environment versions
SQL Server:
SQL Server 2000
Miscellaneous
Thread ID:
01135878
Message ID:
01135878
Views:
83
I want to create a history table for an existing table. This existing table has more then 250 fields. I want to enter a new row in the history table giving info like..which field is changed, old_value, new_value and date when changed.One of the way is to use trigger but how to find out which field changed. I want to use only SQL server and no programming language....Any information is highly appreciated.

Thanks
Bharat
Next
Reply
Map
View

Click here to load this message in the networking platform