sql server mseq: Whats the maimum number of stored procedures you can have in one database?
Would I notice any performance degredation if I had over 2,000?
--

[quoted text, click to view]

Hi we7313,

There is no seperate maximum for number of stored procedures, but there is
a maximum number of object. From Books Online:

"Database objects include all tables, views, stored procedures, extended
stored procedures, triggers, rules, defaults, and constraints. The sum of
the number of all these objects in a database cannot exceed 2,147,483,647"

I never noticed any performance degradation on increasing the number of
stored procedures. If you take very exact measurements, you might see a
small performance degradation because of increased number of recompiles
(if a stored procedure is executed, the execution plan is generated and
stored in cache; if it is rerun later the cached plan is used, but the
cache size is limited).

Best, Hugo
--