Alter all store procedure parameter size- INFORMATION_SCHEMA.PARAMETERS

• anand-679138

  SSC Rookie

  Points: 39

  More actions

  July 29, 2008 at 6:53 am

  #196248

  i need to alter stored procedures that have parameter of Reason or comments.

  i found all stored procedures name by below query

  select * from INFORMATION_SCHEMA.PARAMETERS where (Parameter_Name like '%Comment%' or Parameter_Name like '%Reason%') and Character_Maximum_Length<500

  i need to change all parameters size to 500.