Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Retrieving Column Name thru a Trigger, Possible?

Author  Topic 

KrugerStyles
Starting Member

1 Post

Posted - 2001-06-04 : 12:15:17
Hi, if anyone can help me it would be very much appreciated.

I'm trying to audit the changes on a table using triggers. Creating the Trigger is no problem, but there are approximately 20 or so columns in the table being audited. I need to retrieve the column name that is being changed when the trigger is fired so I can record it to another table that is tracking the changes. Can anyone tell me if this is possible and if so, how can I reference the column name being changed? Thanks a lot.



   

- Advertisement -