Sql Server 2000 : Maximum Capacity Specifications

Found this piece of info in MSDN !

The Maximum Capacity Specifications in Sql Server 2000/97




Columns per SELECT statement : 4096

Columns per INSERT statement : 1024

Nested stored procedure levels : 32

Nested subqueries : 32

Nested trigger levels : 32

Parameters per stored procedure 1024

Tables per SELECT statement 256


The sum of the number of all these objects in a database cannot exceed 2,147,483,647.




Check out more information @

http://msdn2.microsoft.com/en-us/library/aa933149(SQL.80).aspx




Cheerz !