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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

viewing triggers

Status
Not open for further replies.
lfc77

lfc77

Programmer
Aug 12, 2003
218
GB
How can I view all triggers for a particular database? I'm currently trying to find if there are any triggers on a large number of tables by right clicking on the table > all tasks > manage triggers and it's taking forever. Can anybody help me out?


Cheers,

lfc77
 
Sort by date Sort by votes
Look in the sysobjects table.
Alternatively, go to "all tasks" on the database, choose generate SQL Script, and choose to do this for triggers only.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

davism
  • Locked
  • Question
DDL to files for DB artifacts (Stored Procedures, Views, Triggers, etc) in a SQL Server DB. 1
Replies
1
Views
60
TamarGranor
TamarGranor
Emmy2368
  • Locked
  • Question
Inserting start and end timestamps using triggers on multiple rows
Replies
10
Views
136
Emmy2368
Emmy2368
misscrf
  • Locked
  • Question
Triggers and Inserts from Access Append Query?
Replies
2
Views
65
misscrf
misscrf
pjw001
  • Locked
  • Question
Question about triggers
Replies
2
Views
48
pjw001
pjw001
kholladay
  • Locked
  • Question
Viewing commands issues via ASP.NET 1
Replies
3
Views
66
kholladay
kholladay

Part and Inventory Search

Sponsor

Back
Top