Checking parameter length in sp's

select pr.name, p.*, t.name, t.max_length

from sys.procedures pr

inner join sys.parameters p on pr.object_id = p.object_id

inner join sys.types t on p.system_type_id = t.system_type_id

where  p.max_length =24