All Tags »
Tips and Tricks »
Gotcha (RSS)
Sorry, but there are no more tags available to filter with.
-
I answered this question on the MSDN forums: How can I search all my sprocs to see if any use a function? Several people suggested using sp_depends. You can't really depend on sp_depends because of deferred name resolution. Take a look at this
First create this proc
CREATE PROC SomeTestProc
AS
SELECT dbo.somefuction(1)
GO
now create this ...