Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Alter all store procedure parameter size- INFORMATION_SCHEMA.PARAMETERS Expand / Collapse
Author
Message
Posted Tuesday, July 29, 2008 6:53 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 6:56 AM
Points: 9, Visits: 43
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.
Post #542585
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse