Friday, 30 September 2011

Maximum Capacity Specifications for SQL Server

                        SQL Server (32/64-bit)
Nested stored procedure levels 32
Nested subqueries 32
Nested trigger levels 32
Nonclustered indexes per table 999
Parameters per stored procedure 2100
Parameters per user-defined function 2100
REFERENCES per table 253
User connections 32767
XML indexes 249
Rows per table Limited by available storage
Column in table 1024

No comments:

Post a Comment