User Defined Functions Metadata

This video shows you how to use the metadata for user defined functions in SQL Server.

Andrew Novick is a SQL Server consultant building business solutions with the Microsoft tools. His expertise in database design, T-SQL coding, SQL Server security, database performance tuning, and database partitioning can be a valuable asset to many projects. Andrew Novick also offers training and mentoring services to relevant projects. His writing on computing can be seen at his web site ht...

Stephen Oesterreicher on 7/6/2009

It would be nice to know how we can use this infomation.

Bala on 7/6/2009

nice

Lou Gallo on 7/7/2009

Good run-down but too much info. I missed most of it.

Joe Pattison on 7/7/2009

Extremely helpful!

Dean Gross on 8/22/2009

it would have been better if it included the definition of the various codes that sql server uses.

Tonci on 11/18/2009

Really good to know, if for example you remember part of the code of a function, but not its name or in which database you put it. Thank you.

Dean Gross on 10/12/2010

would have been more helpful if there was some discussion about the various parameters that were being used.

Lee Linares on 12/9/2011

Excellent! This was most helpful. Using sp_helptext was much handier than using SSMS to script out a UDF. Thanks.

Michael P. Antonovich on 12/9/2011

Too many functions covered too quickly to digest.