Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Easy way to find where a function is used?
- Thread starter Paula1980
- Start date
mrdenny
Programmer
- May 27, 2002
- 11,595
Check the dependencies on the function.
If you want to manually check, the information is in the sysdepends table. If you drop and recreate the function instead of altering the function when you make changes to it this infomation may not be correct.
If needed you can search the text column of the syscomments table to find what you need.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
![[noevil]](/data/assets/smilies/noevil.gif "[noevil] [noevil]")
If you want to manually check, the information is in the sysdepends table. If you drop and recreate the function instead of altering the function when you make changes to it this infomation may not be correct.
If needed you can search the text column of the syscomments table to find what you need.
Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)
--Anything is possible. All it takes is a little research. (Me)
- Status
Similar threads
- Locked
- Question