Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (eMicrosoft Partne)
  • When: 2 Nov 2011 8:17 AM
  • Last revision by (eMicrosoft Partne)
  • When: 4 Sep 2013 2:43 PM
  • Revisions: 6
  • Comments: 2
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  Database Size Limitations in All Versions and Editions of SQL Server

Database Size Limitations in All Versions and Editions of SQL Server

Database Size Limitations in All Versions and Editions of SQL Server

This article is a stub and it 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

, , , , , , , , , [Edit tags]
Leave a Comment
  • Please add 8 and 1 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 6 Jun 2013 6:57 PM

    Naomi  N edited Revision 2. Comment: Changed title

  • 2 Jun 2013 6:54 PM

    Naomi  N edited Original. Comment: Edit link

Page 1 of 1 (2 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
  • Posted by
    on 2 Jun 2013 6:54 PM

    Naomi  N edited Original. Comment: Edit link

  • Posted by
    on 6 Jun 2013 6:57 PM

    Naomi  N edited Revision 2. Comment: Changed title

Page 1 of 1 (2 items)