What is the best wasy to check if column value was changed

• kmarshall

  Ten Centuries

  Points: 1001

  More actions

  February 4, 2010 at 2:04 am

  #229659

  I have a fairly wide table and want to monitor if a value in any of the fields changes to that I can record the fact.

  Im familiar with the IF UPDATE (myCol) operator (http://msdn.microsoft.com/en-us/library/ms187326.aspx), but this just tells me if the column was updated whether the column data changed or not. I want to know only if the column data changed.

  I realise another way would be to compare the INSERTED and DELETED values but I was hoping there'd be a more elegant and cheap way of doing this.

  Can anyone offer any suggestions?

  Thank for your time.

  Windows 2008 Server | SQL Server 2008

• Dave Ballantyne

  SSC-Dedicated

  Points: 33667

  More actions

  February 4, 2010 at 2:08 am

  #1113541

  Try Change data capture http://msdn.microsoft.com/en-us/library/cc627397.aspx

  ---

  
  Clear Sky SQL
  My Blog[/url]