Size of stored procedure



 
Stored procedures are special objects available in sql server
It is a collection of transact sql statements that can take or return user supplied parameters.

It s a p recompiled statements where all the preliminary parsing operations are performed and the statements are ready for execution.

Maximum size of stored procedure is 128 MB.