CODEWITHSUNDEEP
sql
buddy
buddy

Reputation: 815

SQL Express Database size limit via query

We know the max size of SQL data files allowed in SQL express editions are 2 GB, 4 GB , 10 GB for SQL 2000, 2005, 2008 express respectively.

Is there any way we could see the max size of the database allowed via SQL query?

Upvotes: 0

Views: 811

Answers (1)

Mitch Wheat
Mitch Wheat

Reputation: 300549

The Max size is exactly that. I'm not aware of any query you can run to get this information directly.

You could get the SQL Server version: 

SELECT @@VERSION

and infer from that.

Upvotes: 2

Related Questions