如何查询和获取Sql Server 2008 R2 Express版支持的最大数据库大小？ [英] How do I query and Obtain the max DB size supported by Sql Server 2008 R2 Express edition ?

问题描述

我在考虑SQL Server 2008 R2 express edition（10GB）支持的Max DB大小是否存储在其中一个系统表中？如果是这样，我在哪里以及如何查询它。



目前，我查询数据库以获取它的当前大小并与10GB的硬编码值进行比较以查看是否它超过了它的上限。正在考虑，如果我可以用DB的查询替换硬编码来获得它的最大支持大小。



任何建议都非常感谢。



谢谢。

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.

推荐答案

最大数据库大小是硬编码的，您无法从其中一个系统表中查询它。 ..

说实话，我甚至不明白为什么你应该......

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...

这篇关于如何查询和获取Sql Server 2008 R2 Express版支持的最大数据库大小？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！