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 |
|
dasu
Posting Yak Master
104 Posts |
 Posted - 2004-10-19 : 06:16:56
|
| iam facing one problem like thishere sp1 ie stored procedure1 sp1begin sp2endhere iam calling sp2 in sp1so this sp1 and sp2 .....all stored procedures are in a single folderi wrote one batch script which will execute all stored procedureswhich are there in that folder.but here i hve some dependencies so i have to execute some of them before executing some spsso.i ahve to find dependenciesand i ahve to find execution status (whether it s allready executed or not) where can i get this all information in systables pleasesuggest me proper solutionregardsdasu.g |
|
|
surefooted
Posting Yak Master
188 Posts |
Posted - 2004-10-19 : 09:41:21
|
| You can use sp_depends to see what object references another object. To see if a stored procedure has been executed or not, use profiler to run a trace.-JonNow a "Yak Posting Veteran". |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-19 : 14:31:42
|
| In my experience sysdepends is not very reliable. If you have self-referencing SProcs then sysdepends will not be properly, and accurately, formed as the Sprocs are created. And then it will be unreliable thereafter.Instead ofDROP SPRoc1DROP SPRoc2CREATE SPRoc1CREATE SPRoc2(as EM "Generate SQL" creates)we doDROP SPRoc1CREATE SPRoc1DROP SPRoc2CREATE SPRoc2which makes sysdepends a little more reliable - but, even so, if we get "Unable to update sysdepends ..." type messages we re-run the script until there are no such message.Kristen |
|
|
|
dasu
Posting Yak Master
104 Posts |
Posted - 2004-10-20 : 04:35:33
|
| thanks for solution but i want some what clear so i need how many tables are populated when we try to execute stored procedure .pleas tell me the list of system tables pleasemake me favourregardsdasu.g |
|
|
|
|
|
|
how to find dependencies for stored proc