Stored Procedure size

[MikeL]

Is there an easy way to get the size in bytes that a stored procedure takes up in storage space?
Thanks.

[rmiao]

You can check table size of syscomments in the db.

[MAK]

select sum(datalength(text)) * 2 from syscomments where object_name(id) = 'yourprocname'

*2 because it is nvarchar = 2 bytes for one char

[skhanal]

It may have to be

select sum(datalength(text)) * 3 from syscomments where object_name(id) = 'yourprocname'

as the text is also stored as binary in ctext column.

Whatever it is, you should not be too much concerned about the space it takes, in any database it will be a fraction of total size.