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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-10 : 08:15:52
|
| Sivagurunathan writes "Hi ,I would like to know any system stored procedure in sql/server returns all the dependent procedure name when index name is passed as input to the system stored procedure. Any tool available to find this is highly appreciable.Thanks and Regards,sivaguru" |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2004-06-10 : 09:11:09
|
| Can you clarify what exactly you are after?? |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-10 : 10:06:21
|
| There is none. You can find any stored procedure that has the index as a hint (meaning it is specificied that it has to use the index in the text of the stored procedure) by searching syscomments and comparing to the name field on sysindexes. Other then that, you would have to look at every table/column accessed by every stored procedure, then see what indexes correspond. Would be quite the task.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Need to find stored procedures for a particular index