[dba-SQLServer]Tracking updates

Billy Pang tuxedo_man at hotmail.com
Fri Nov 7 13:31:35 CST 2003


Create an AFTERUPDATE trigger on that table that checks for updated columns 
using the UPDATED() function.

Billy


>From: "Martin Reid" <mwp.reid at qub.ac.uk>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: [dba-SQLServer]Tracking updates
>Date: Fri, 7 Nov 2003 08:18:42 -0800
>
>Is there a simple way to catch when a table was updated?
>
>I have a table in SQL Server, same table in a scanner (more or less)
>
>I dont want to download or upload if there have been no changes to the
>table.
>
>Or is there another approach to this?
>
>Martin
>
>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963



More information about the dba-SQLServer mailing list