SQL Server Performance Forum – Threads Archive
Generic Script for Creating Triggers!
Probably this is a vague question. I need to write a generic script/sp that will generate scripts for existing TRIGGERS from all tables and execute in new database. I think it can be done BUT my problem is how do I do this for all tables at once? Cursor or Dynamic SQL? Just curious, if anyone has suggestion/solution for this?
Name
———
Dilli Grg (1 row(s) affected)
<br />This might be a developer question than DBA. Please feel free to move around.[<img src=’/community/emoticons/emotion-1.gif’ alt=’
![Smile :) :)](styles/default/xenforo/smilies/smile.png)
Just use a cursor. Below is a link of a script I write what searches an entire server for a word in a script /proc etc. You can lift that logic and put in any code you want http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=20826 Michael
MCDBA "The statistics on sanity are that one out of every four persons is suffering from some sort of mental illness. Think of your three best friends — if they’re okay, then it’s you!"
Thanks Mike for the response. My question was more of how to generate trigger scripts from all existing tables than searching for string in a server unless I am missing something. But I can certainly use this in some other requirements though.
Name
———
Dilli Grg (1 row(s) affected)
]]>