This article is related to
this MSDN thread
According to this thread, the data file size limitation is not exposed through the query and most likely is hardcoded into the SQL Server assembly code.
We can find data file limitations in BOL and we can create our own table to hold this information based on SQL Server version and edition. The aforementioned thread provides the possible table:
CREATE
TABLE
SQLServerVersions (
VersionNumber
VARCHAR
(20)
NOT
NULL
PRIMARY
KEY
,
SQLEdition
VARCHAR
(100)
NOT
NULL
FileSizeData
NUMERIC
(19,0),
FileSizeLog
NUMERIC
(19,0),
DatabaseSize
NUMERIC
(19,0),
ROW_ID
INT
IDENTITY(1,1)
)
INSERT
SQLServerVersions (
'10.50'
,
'Standard Edition'
, 1099511627776, 1099511627776, 576443160117379072);
SELECT
*
FROM
SQLServerVersions
BOL link
http://msdn.microsoft.com/en-us/library/ms143432.aspx
See Also
Other Languages
This article is also available the following languages: