User defined scalar functions - how do I find the owner of these?

• ta.bu.shi.da.yu

  Hall of Fame

  Points: 3985

  More actions

  October 15, 2008 at 5:54 am

  #199376

  You always have to prepend user-defined scalar functions with the database owner, and I work with a software product that needs to run the UDF under any account that the end user might decide best to use.

  How would I use SQL to detect the owner of the UDF in SQL Server 2005?

  Random Technical Stuff[/url]

• Atif

  Hall of Fame

  Points: 3578

  More actions

  October 16, 2008 at 2:51 am

  #885690

  use following by giving scalar function name

  sp_help 'scalar function name'

  DBDigger Microsoft Data Platform Consultancy.