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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Maximum in stored procedure?

Author  Topic 

danyeung
Posting Yak Master

102 Posts

Posted - 2006-04-05 : 13:07:48
Is there a maximum length in a stored procedure? If there is, what is the maximum?

Thanks.
DanYeung

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-04-05 : 13:11:37
what do you mean by length?

if you mean rows, then there's not a limit you will pass anytime soon... if there is one.

Go with the flow & have fun! Else fight the flow
Blog thingie: [URL="http://weblogs.sqlteam.com/mladenp"]
Go to Top of Page

russellsoft

9 Posts

Posted - 2006-04-05 : 13:16:54
What maximum?
Go to Top of Page

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2006-04-05 : 13:18:51
I read in the following there is a limit of 250 MB

Page 11 of
http://itcourseware.com/Webpdfs/webap-sql2kl2.pdf

Srinika
Go to Top of Page

danyeung
Posting Yak Master

102 Posts

Posted - 2006-04-05 : 13:19:54
I meant if there is maximum lines of codesin the stored procedure? Thanks.

Thanks.
DanYeung
Go to Top of Page
   

- Advertisement -