The following table lists the system limits for various SQL Server objects. These are the set limits for SQL Server. Practical limits may often be less and will vary by application.
| Object | Limits |
|---|---|
| Devices | 256 devices per SQL Server. Maximum size for each logical device is 32 gigabytes (GB). (1) |
| Databases | 32,767 databases. The minimum database size is 1 MB. The maximum database size is 1 terabyte (TB). (2) |
| Tables | 2 billion tables per database. The maximum number of bytes per row is 1962 (excluding text and image columns). The maximum table size is about 1 TB. |
| Columns | 250 columns per table. |
| Indexes | 1 clustered index per table. 249 nonclustered indexes per table. A composite index can have up to 16 columns. |
| Triggers | Maximum of three triggers per table ¾ one each for INSERT, UPDATE, and DELETE. Triggers can have 16 levels of nesting. |
| Stored procedures | A stored procedure can contain as many as 255 parameters and have up to 16 levels of nesting. |
| User connections | 32,767 (3) |
| Open databases | 32,767 |
| Locks | 2 billion (2,147,483,647) |
| Open objects | 2 billion (2,147,483,647) |
| (1) The maximum total addressable storage is 8 TB (256 devices * 32 GB maximum per device). (2) Each logical device can be a maximum of 32 GB, and each database can have a maximum of 32 device fragments (32 GB * 32 = 1 TB). (3) For Microsoft SQL Server 6.0. Microsoft SQL Workstation 6.0 has the same capabilities as Microsoft SQL Server, except that it is a single-user licensed product that supports a maximum of 15 simultaneous database connections. |
|