SQL Server Performance Forum – Threads Archive

Information_Schema

Hi,
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
Aneesh

---

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
Madhu

---

And this is not at all related to Information_schema Views any way Madhivanan Failing to plan is Planning to fail

---

]]>