[dba-SQLServer]Tracking updates

Billy

I can find no reference to an UPDATED() function???

Martin



----- Original Message ----- 
From: "Billy Pang" <tuxedo_man at hotmail.com>
To: <dba-sqlserver at databaseadvisors.com>
Sent: Friday, November 07, 2003 11:31 AM
Subject: Re: [dba-SQLServer]Tracking updates


> 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
>
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
>
>