Re: How to generate scripts from existing triggers?
From: Hari (hari_prasad_k_at_hotmail.com)
Date: Fri, 2 Jul 2004 15:30:11 +0530
You can use "Generate SQL scripts" from Enterprise manager to script
How to do:-
1. Open Enterprise manager -- Select database and right click and select all
2. Select "Generate SQL Script
3. In General click "Show ALL", Check "All tables" check box
4. In format -- Uncheck both "Generate the CREATE " and "Genereate the DROP
" object -- check box
5. In options -- check the "SCRIPT TRIGGER"
6. Go back to General - "preview " button to preview , CLick ok to save the
triggers to a specific location
in hard disk.
-- Thanks Hari MCDBA "Michael" <firstname.lastname@example.org> wrote in message news:e$uSf8AYEHA.3156@TK2MSFTNGP12.phx.gbl... > Hi All, > > SQL2000 server. > > I have a database system with more than 500 user tables, each table has 2 or > 3 triggers. > I am going to upgrade this database to a new application version. > I have hundred more table need to be updated, before updating those tables, > I need to remove all the triggers, then modify tables structure, and then > re-apply those triggers. > > Could you please tell me how to generate scripts for those existing triggers > from my current database? > I dont want to use SQL analyze table by table manually do it, any way to > generate the scripts quickly? > > Thank you > > Michael > > > > >