Connecting Tech Pros Worldwide Help | Site Map

Using a Trigger to determine when a column was changed

 
LinkBack Thread Tools Search this Thread
  #1  
Old August 5th, 2008, 05:05 PM
Alex
Guest
 
Posts: n/a
Default Using a Trigger to determine when a column was changed

Hi,

I'm new to Triggers, so forgive the elementary question. We have a
process that saves data from a VB2005 form into a table in MS SQL
2005, and it saves all data whether the user changed the value or
not. Is it possible to create a trigger for this table where a log
can be written to if a value is updated with different data? Since
technically all data in the table is being updated I wasn't sure if a
trigger could distinguish between data that didn't change and data
that did.

Thanks --

Alex

  #2  
Old August 5th, 2008, 07:05 PM
--CELKO--
Guest
 
Posts: n/a
Default Re: Using a Trigger to determine when a column was changed

>Is it possible to create a trigger for this table where a log can be written to if a value is updated with different data? <<

Read this before you make this design error and get in trouble with
the auditors:

http://www.tdan.com/view-special-features/8135
 

Bookmarks

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Popular Articles

What is Bytes?

We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights. Get the best answers to your questions from over 220,989 network members.