Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
keyursoni85
Posting Yak Master
233 Posts |
 Posted - 2011-11-17 : 09:19:08
|
| How can I find list of triggers created on specific table? |
|
|
daniel.nospam
Starting Member
11 Posts |
Posted - 2011-11-17 : 09:31:24
|
| SELECT *FROM sys.triggers trg INNER JOIN sys.tables tab ON tab.object_id = trg.parent_idWHERE tab.name = '<table_name>' |
 |
|
|
keyursoni85
Posting Yak Master
233 Posts |
Posted - 2011-11-17 : 09:32:04
|
| Great thanks. |
|
|
|
|
|
|
list of trigger