try alter table..alter column and then rebuild the indexes if you have any on that column...this should fix.

OR

drop and re-create the column.....which is much safer as it is suggested by...

run this:-

select text from sys.syscomments

where text like '%Exec Proc2%'