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 |
|
patshaw
Posting Yak Master
177 Posts |
 Posted - 2007-12-06 : 15:32:46
|
| The scenario:I have 2 tables, tableA and tableB.tableA has a trigger that inserts a row into tableB when an action occurs.If I run sp_depends on tableB will the trigger on tableA show in the dependency list? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-12-06 : 15:54:22
|
| What does it show when you setup this exact scenario?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
patshaw
Posting Yak Master
177 Posts |
Posted - 2007-12-06 : 19:04:35
|
| I haven't set it up Tara. It was just a question that came up in conversation today and I just wondered if anyone had a quick answer........... |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-12-06 : 19:46:45
|
quickest answer is to try it yourself.
elsasoft.org |
|
|
|
Pat Shaw
Starting Member
14 Posts |
Posted - 2007-12-07 : 02:42:50
|
| Not as quick as yours Jez :-) |
|
|
|
|
|
|
sp_depends