Hi Lowell,

Thanks for the response, tried your query but no luck.

Even just a simpler version didn't work:

SELECT * from sys.procedures where name = 'XXXX'

SELECT * from sys.procedures where name like '%XXXX%'

I tried this against A WORKING databases and it still didn't work, does "sys.procedures" store functions?

ON A WORKING DATABASE - changing your query to use sys.objects works perfectly.