Estimating stored procedure size

To get a rough estimate of the size of a single stored procedure, view, or trigger, use:

select(count(*) / 8) +1
    from sysprocedures
where id = object_id("procedure_name")

For example, to find the size of the titleid_proc in pubs2:

select(count(*) / 8) +1
    from sysprocedures
where id = object_id("titleid_proc")
----------- 
          3