How do I query and Obtain the max DB size supported by Sql Server 2008 R2 Express edition ?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

Hi,

I was contemplating if the Max DB size supported by SQL server 2008 R2 express edition(10GB) is stored in one of the system tables ? If so, where and how do I query it.

Currently, I query the DB to obtain it's current size and compare with a hard coded value of 10GB to see if it exceeded its upper limit. Was thinking, if I can replace the hard coding with a query to the DB to obtain it's max supported size.

Any suggestions are greatly appreciated.

Thanks.

Posted 29-Jun-15 8:20am

JamesHadleyChase

Add a Solution

Comments

RossMW 29-Jun-15 16:09pm

I cant imagine Microsoft building in a means of letting you exceed the designed limitation of express. Otherwise they would never sell any of the other versions. Legally I should imagine this would be a no no..

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kornfeld Eliyahu Peter · Answer 1 · 2015-06-29T10:45:00

Solution 1

Max DB size is hard-coded and you can not query it from one of the system tables...
To be honest I can't even see why you should...

Posted 29-Jun-15 10:45am

Kornfeld Eliyahu Peter