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.