Sergey must be sleeping, ;) Well, my answer is yes I would like you to send me the code to do that when you can. It also would help me on learning using SQL-DMO.
I also have another question: I created my database at hand, I mean manually in the enterprise manager as I can't afford a Database design software. But I took the time to comment every table and every field. Is there any way to get that information and have a document of everuthing?
TIA
>
>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.