Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ahmeds08
Aged Yak Warrior
737 Posts |
 Posted - 2010-12-07 : 01:56:42
|
| hello everybody, is there any way to change the default size(128 mb) of a stored proc in sql server. |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-12-07 : 04:15:27
|
What do you mean by default size...?? From Books Online (http://msdn.microsoft.com/en-us/library/ms187926.aspx#sectionToggle2): quote:
General RemarksThere is no predefined maximum size of a procedure.
- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-12-07 : 04:23:52
|
| the default size sql provides for a stored procedure is 128 mb.now my question is can we changes the size .i mean can we increase or decrease the size of the procedure. |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-12-07 : 04:32:31
|
| Where do you get this information from? I just gave you a link to the SQL Server documentation where it says that there is no predefined maximum size of a stored procedure so as far as I can understand what you are saying is wrong.- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-12-07 : 04:45:33
|
| FYI 'http://technet.microsoft.com/en-us/library/aa214375(SQL.80).aspx' |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-12-07 : 05:15:46
|
| Ok, so this is sql server 2000...no mention of that. Is this a problem for you? What do you want to achieve? If you need procedures above 128 MB I'd advocate a redesign...not changing the limit. Alternatively an upgrade to SQL Server 2005/2008 where this is not a problem.- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
|
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2010-12-07 : 05:19:15
|
| so you mean to say that if i wold have a procedure of 128 mb i should change the design.but i wanted to know if there was a way of changing the size.any way thanx for your suggestions. |
|
|
|
|
|
|
changing default size of a stored proc