Determining Nullability of a procedure parameter

Published 24 July 09 06:50 PM | MartinBell

In my posting about NOCOUNT and linked servers I provided a script to create the necessary shell procedures that enabled NOCOUNT to be set ON and avoiding the problems of ROWCOUNTs being returned by linked servers.

One of the problems I encountered when creating the script was that there is no metadata held on whether the procedure parameter was optional i.e. it had a default. To get around this I gave all parameters default values which is not the ideal solution, but in the circumstances was the best solution I could think of.

Following a recent post in the newsgroup by MVP Aaron Bertrand I have become aware that this problem does have a connect item already raised for it at
http://connect.microsoft.com/sql/feedback/ViewFeedback.aspx?FeedbackID=234143. Aaron has attached a work around to the connect item. which parses the T-SQL code and could be incorporated into my script. Anyone wishing to see expanded meta data for stored procedure parameters may want to add their vote.

Filed under: ,

Comments

# Dew Drop – Weekend Edition – July 25-26, 2009 | Alvin Ashcraft's Morning Dew said on July 26, 2009 04:27 PM:

Pingback from  Dew Drop – Weekend Edition – July 25-26, 2009 | Alvin Ashcraft's Morning Dew

This Blog

SQL Blogs

Syndication