SQL Server Limits
Size of the database file - the whole content of a database is stored in a single file. The file size is limited by the file system used. E.g. for Windows file system FAT32 the maximum file size is 4GB, Windows file system NTFS doesn't have a size limit.
Number of records in a database table is (theoretically) 2^32-2 (4 294 967 294) at most. Another exceptions apply before this one.
A part of database table consisting of fixed-lenght data cannot be bigger than c. 3.9 GB. This limit can be broken if checkbox Allow tables bigger than 4GB in the Create a new local server window is checked before then database creation.
Number of table columns - since version 9.5 and higher limited to 65535 columns.
