I have a Table-valued Function and a large number of views that potentially use it, I would like to produce a list of views in which the function is called as I need to edit each to make changes.
I am using SQL Server 2005, I have used the right-click to look at dependencies and this brings up a short list of SPs in which the function is used. I know there are views that call the function.
I hope this makes sense.
View Complete Post