Posted by Ots on 05/02/07 20:24

I'm using SQL 2000, which is integrated with a VB.NET 2003 app.

I have an Audit trigger that logs changes to tables. I want to apply
this trigger to many different tables. It's the same trigger, with the
exception of the table name. I could manually change the table name in
the trigger and create it, over and over, but I'd like to automate
this - by iterating through the collection of tables and passing the
tablename to something that would create the audit trigger for that
table.

Any ideas? With any scripting language I can create the text of the
CREATE TRIGGER procedure for each table and use simple text
replacement, but how do I automate that inside of SQL?

Thanks.

• Next in forum: Suggestions on how to convert MS Word Data Dictionary to SQL Server "Description"
• Prev in forum: Re: INSERT - one record at a time
• Thread view: One trigger, many tables - how to automate?

[Reply to this message]