change datatype of all parameters with same name

neilxneilx Posts: 14
edited May 20, 2008 3:55PM in SQL Refactor Previous Versions
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 DEddie D Posts: 1,726 Rose Gold 5
    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 Davis
    Product Support Engineer
    Red Gate Software Ltd
    e-mail: [email protected]
    Eddie Davis
    Senior Product Support Engineer
    Redgate Software Ltd
    Email: [email protected]
Sign In or Register to comment.