Friday, March 23, 2012

How many Stored Procedure can I add to a database in SQL SERVER 2005 Express edition?

How many Stored Procedure can I add to a database in SQL SERVER 2005 Express edition?

I remember that only 32 Stored Procedure can be added to a database in SQL SERVER 2005 Express edition,
but now I can add over 32 Stored Procedure to a database from SQL Server Management Studio Express CTP!
How many Stored Procedure can I add to a database in SQL SERVER 2005 Express edition?

I'm not aware of any limitation to the number of stored procedures in any version of SQL Server, including MSDE and SQL Express. I think you might be confused with 32 nested stored procedures, which means that stored procedure A can call sp B which can call sp C, etc 32 levels deep.

No comments:

Post a Comment