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 |
|
sqllearner
Aged Yak Warrior
639 Posts |
 Posted - 2004-09-08 : 14:24:11
|
| using sp_depends 'procedure name' system procedure iam getting the dependencies showing the update, selected and columns.Is there any way to differentiate between the update and insert in here |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-08 : 14:26:30
|
| I wouldn't rely on sp_depends anyway though as it might not be accurate due to the order in which the objects were created. SQL Server allows you to create a stored procedure that references an object that doesn't exist. This causes sp_depends to not be accurate.Tara |
 |
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2004-09-08 : 14:29:16
|
| But if we recompile the stored procedure it should be able to pick it up right..else what should I do |
|
|
|
sqllearner
Aged Yak Warrior
639 Posts |
Posted - 2004-09-08 : 14:51:04
|
| Is there any system stored procedure or query I can use for getting the result |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-08 : 14:52:11
|
| I don't believe there is. You would need to run SQL Profiler to view this information.Tara |
|
|
|
|
|
|
issue with stored procedure