How many stored procedures can a database have?

Question

How many stored procedures can a database have?

Vivien Xing

SSChampion

Points: 12297
More actions
June 14, 2007 at 10:56 am

#103376

Any limitation?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Antares686 SSC Guru Points: 125444 More actions · Answer 1

I don't recall any limit to the number of objects that can exist in the database except in the case of MSDE (Desktop Edition) which was a DB size limit not specifically objects. As many objects can be supported as you can think of.

Vivien Xing SSChampion Points: 12297 More actions · Answer 2

Thank you for your reply. I am wondering whether it is up to 2,147,483,647 before overflow occurs as the ID column in sysobjects is int data type. I can not find any specs on this.

I noticed that some id ranges seem be reserved. The actual number should be less than 2,147,483,647 then.

Jeff Moden SSC Guru Points: 1004576 More actions · Answer 3

That number is correct... check in Books Online under "specifications-SQL Server objects"

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Vivien Xing SSChampion Points: 12297 More actions · Answer 4

Vivien Xing

SSChampion

Points: 12297

June 14, 2007 at 8:10 pm

#713107

I found it. Thank you Jeff.

How many stored procedures can a database have?

Cookies on SQLServerCentral