Alter all store procedure parameter size- INFORMATION

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Alter all store procedure parameter size-...

Alter all store procedure parameter size- INFORMATION_SCHEMA.PARAMETERS

Rate Topic

Display Mode

Topic Options

Author

Message

anand-679138

Posted Tuesday, July 29, 2008 6:53 AM

Forum Newbie

Group: General Forum Members
Last Login: Friday, May 03, 2013 4:30 AM
Points: 9, Visits: 33

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 »

Permissions