{"id":140,"date":"2012-04-16T11:16:59","date_gmt":"2012-04-16T11:16:59","guid":{"rendered":"https:\/\/sqlserverlearner.azurewebsites.net\/2012\/04\/16\/what-is-the-maximum-size-of-a-stored-procedure-in-sql-server\/"},"modified":"2012-04-16T11:16:59","modified_gmt":"2012-04-16T11:16:59","slug":"what-is-the-maximum-size-of-a-stored-procedure-in-sql-server","status":"publish","type":"post","link":"https:\/\/sqlserverlearner.com\/2012\/04\/16\/what-is-the-maximum-size-of-a-stored-procedure-in-sql-server\/","title":{"rendered":"What is the Maximum Size of a stored procedure in SQL Server?"},"content":{"rendered":"<p>table.hovertable {<br \/>\nfont-family: verdana,arial,sans-serif;<br \/>\nfont-size:11px;<br \/>\ncolor:#333333;<br \/>\nborder-width: 1px;<br \/>\nborder-color: #999999;<br \/>\nborder-collapse: collapse;<br \/>\n}<br \/>\ntable.hovertable th {<br \/>\nbackground-color:#c3dde0;<br \/>\nborder-width: 1px;<br \/>\npadding: 8px;<br \/>\nborder-style: solid;<br \/>\nborder-color: #a9c6c9;<br \/>\n}<br \/>\ntable.hovertable tr {<br \/>\nbackground-color:#d4e3e5;<br \/>\n}<br \/>\ntable.hovertable td {<br \/>\nborder-width: 1px;<br \/>\npadding: 8px;<br \/>\nborder-style: solid;<br \/>\nborder-color: #a9c6c9;<br \/>\n}<\/p>\n<p>What are the maximum Bytes in source text of a stored procedure in SQL Server?<br \/>\nSQL Server Supports Lesser of 250 MB or Batch Size in source text of a stored procedure.<\/p>\n<table class=\"hovertable\">\n<tbody>\n<tr align=\"center\">\n<th>Max Capacity For<\/th>\n<th>SQL Server 2012<\/th>\n<th>SQL Server 2008 R2<\/th>\n<th>SQL Server 2008<\/th>\n<th>SQL Server 2005<\/th>\n<\/tr>\n<tr>\n<td>\nMaximum Bytes in source text of a stored procedure in SQL Server\n<\/td>\n<td>\nLesser of 250 MB or Batch Size\n<\/td>\n<td>\nLesser of 250 MB or Batch Size\n<\/td>\n<td>\nLesser of 250 MB or Batch Size\n<\/td>\n<td>\n&#8211;\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>\n<a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/ms143432.aspx\">http:\/\/msdn.microsoft.com\/en-us\/library\/ms143432.aspx<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>table.hovertable { font-family: verdana,arial,sans-serif; font-size:11px; color:#333333; border-width: 1px; border-color: #999999; border-collapse: collapse; } table.hovertable th { background-color:#c3dde0; border-width: 1px; padding: 8px; border-style: solid; border-color: #a9c6c9; } table.hovertable tr { background-color:#d4e3e5; } table.hovertable td { border-width: 1px; padding: 8px; border-style: solid; border-color: #a9c6c9; } What are the maximum Bytes in source text of a stored procedure&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[41],"tags":[1266,1267,1268,1269,1270,1271,1272,1273,1274,1275,1276,1277,1278,1279,1280,1281,1282,1283,1284,1285,1286,1287,1288,1289],"_links":{"self":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/140"}],"collection":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/comments?post=140"}],"version-history":[{"count":0,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/posts\/140\/revisions"}],"wp:attachment":[{"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/media?parent=140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/categories?post=140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/sqlserverlearner.com\/wp-json\/wp\/v2\/tags?post=140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}