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 |
|
nishita_s
Yak Posting Veteran
61 Posts |
 Posted - 2008-12-31 : 01:26:19
|
| How to find tables with triggers?? |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2008-12-31 : 01:32:42
|
| to get the details of triggers present in databaseselect * from sys.objects where type = 'tr'to get the tables used in this triggerexec sp_depends 'triggername' |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-12-31 : 01:33:39
|
| select object_name(parent_id) as table_name,name as trigger_name from sys.triggersMadhivananFailing to plan is Planning to fail |
|
|
|
Jai Krishna
Constraint Violating Yak Guru
333 Posts |
Posted - 2008-12-31 : 01:40:13
|
| select object_name(parent_object_id) as tablename from sys.objects where type = 'tr'Jai Krishna |
|
|
|
nishita_s
Yak Posting Veteran
61 Posts |
Posted - 2008-12-31 : 02:35:21
|
| Madhivanan ur suggested query helped me to give desired o/p.Thanks to all for replying. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-12-31 : 03:16:01
|
quote:
Originally posted by nishita_s
Madhivanan ur suggested query helped me to give desired o/p.Thanks to all for replying.
You are welcome  MadhivananFailing to plan is Planning to fail |
|
|
|
Jai Krishna
Constraint Violating Yak Guru
333 Posts |
Posted - 2008-12-31 : 03:17:45
|
| WelcomeJai Krishna |
|
|
|
|
|
|
How to find tables with triggers??