How to find all the Triggers in an instance

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Dutta, Amartha SSC Eights! Points: 945 More actions · Answer 1

Use yourdbname

SELECT * FROM sysobjects WHERE xtype = 'TR'

Madhivanan-208264 SSCertifiable Points: 7516 More actions · Answer 2

EXEC sp_msforeachdb 'select * from ?..sysobjects where xtype=''tr'''

or

Madhivanan

Failing to plan is Planning to fail

Dutta, Amartha SSC Eights! Points: 945 More actions · Answer 3

Thanks a lot... Learnt a completely new stored procedure....

Madhivanan-208264 SSCertifiable Points: 7516 More actions · Answer 4

amartha_dutta (2/19/2009)
Thanks a lot... Learnt a completely new stored procedure....

You are welcome

Madhivanan

Failing to plan is Planning to fail

Cookies on SQLServerCentral