change datatype of all parameters with same name

neilx

How could I change the parameter datatype automatically in dozens of stored procedures to reflect a new datatype. E.g.:

@LanguageCode nvarchar(2) should be changed everywhere to
@LanguageCode varchar(6)

Eddie D

Thank for your post into the forum and sorry for the delay in replying to you.

Unfortunately SQL Refactor will not help you in this scenario. I do not known of another Red Gate product that will help you. Sorry.

Many Thanks
Eddie

Eddie Davis
Product Support Engineer
Red Gate Software Ltd
e-mail: support@red-gate.com