>Hi!
>
>When using triggers in SQL Server I would like to know which fields of a modified record have been changed, just like VFP's GetFldState() function. Is there any equivalent function or script?
>
>TIA
In triggers you can use UPDATED() function.
But you can't use if to check ALL fields.
And the question is WHY you need this?
In triggers you get only updated records.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
