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开发者_Go百科 could see the max size of the database allowed via SQL query?

---

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.