Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to script ONLY ALL Trigger
- Thread starter kim1
- Start date
tlbroadbent
MIS
Try this.
Select
'-- Trigger Name: ' + o.Name +
char(10) + char(10) +
c.text + char(10) + 'GO' +
char(10)
From sysobjects o
Join syscomments c
On c.id = o.id
Where o.type='tr' Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.
- Status
Similar threads
- Locked
- Question