Forum Replies Created

Viewing post 1 (of 2 total)

  • RE: Create triggers on all tables

    Ha! Got it. Forgot about the first statement thing. So I tried:

    exec sp_msforeachtable

    'if dbo.checkforcolumn(''?'',''columnname'')=''exists''

    begin

    exec ''create trigger foo on ?

    for insert, update

    as

    ...

Viewing post 1 (of 2 total)