>Thanks Sergey, this time George Tasker was faster than you ;), anyway thanks again, because what was more difficult was to make the trigger. But here is another question: Is there a way to use the same trigger for all the tables in the database? I'm using exactly the same fields in all of them but I would just have to create the same trigger for nearly 120 tables. Do you know of something that can solve this?
>
>TIA
>
Luis,
I beat Sergey again (he must be slipping< bg > & < g,d&rfsb >).
The way to do this is via SQL-DMO. I assume that you have the Enterprise Manager that's allowing you to addd the triggers. SQL-DMO (the DMO stands for Distributed Management Object), exposes the Enterprise manager as a COM object. Anything you can do there, you can do programmatically with the COM object. I've a sample at the office of doing exactly this. If you'd like me to post the code, just ask.
George
Ubi caritas et amor, deus ibi est