Home Forums SQL Server 2008 SQL Server 2008 - General UDF not there or invisible RE: UDF not there or invisible

  • May 3, 2015 at 9:07 am

    #1795241

    TeraByteMe (5/3/2015)

    I started a new position recently and my Manager says there is a UDF out on a database but I can't find it anywhere not under object explorer in SSMS nor when querying the sys.functions view.

    I have been working around sql server quite a while but I have never run across this kind of thing before. I have read/write permissions on the database. Is it possible that the functions is really there but I don't have permissions to see it?

    Thanks

    Quick suggestion, search for it in sys.all_SQL_modules, if you cannot find it there then add a permission to view definitions.

    😎