Information_Schema | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


How to know what are the fields value got changed while updation.
For example
Table name Issue contains Moduleid , Userid, componentid etc..
In an update i changed only componentid..
How to track this using trigger. Regards
Hi aneesh,
Is your question really related to 2005?
If yes then, you can find out the values being updated in stored procedure as well by accessing virtual tables. Please take a look at them in BOL.
Also read about @@rowcount which helps you in finding how many no of rows modified.
Hi, In BOL see IF Update() and COLUMNS UPDATED() functions
And this is not at all related to Information_schema Views any way Madhivanan Failing to plan is Planning to fail