Triggers help - SQL Server Forums

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

Transact-SQL (2000)

Triggers help

Author

Topic

PatDeV
Posting Yak Master

197 Posts

Posted - 2006-04-18 : 10:54:45

Hi all,

I have table A with column confirm changes.

now they want to create audit on that column to keep track.
so how can i do that with trigger to update audit table with the changes.

please help

Thanks

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-04-18 : 10:58:09

http://www.nigelrivett.net/SQLTriggers/Triggers_2_Creating_Audit_Trails.html

Madhivanan

Failing to plan is Planning to fail

PatDeV
Posting Yak Master

197 Posts

Posted - 2006-04-18 : 15:06:40

it talks about the creating new audit table. but
I have audit table teststamp which keeps the records that are being changed by thirdparty tool.
but i have to reate from scratch!!

for eg.

for test table column columnA is changes
the teststamo table need to keep audit for who changed, what time, what, and currentdate!

How can i do that.

Please help!! totally confuse!!

Thanks

PatDeV
Posting Yak Master

197 Posts

Posted - 2006-04-18 : 15:15:29

And also which column changed!!
thanks

PatDeV
Posting Yak Master

197 Posts

Posted - 2006-04-20 : 09:09:49

please anyone who can provide some more light on this please.

Kristen
Test

22859 Posts

Posted - 2006-04-20 : 15:02:26

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=55210&SearchTerms=Triggers+to+audit+changes

Kristen