I have installed SQL Express 2008 Express version on one of my staging server.
But one of the database on above mentioned server was previously set to "SQL Server 2005(90)" compatibility level in Option section. and I am getting the Database size exceeds license limit of 4096MB per Database error while rebuilding the Indexes.
Now I have changed the compatibility level in Option section to "SQL Server 2005(100)". But still I am getting the same above error.
Following are my SQL Server version information:
Microsoft SQL Server Management Studio = 10.0.2531.0
Instance ID = MSSQL10.SQLEXPRESS
Microsoft Data Access Components (MDAC) = 6.1.7600.16385
Microsoft MSXML = 3.0 6.0
Microsoft Internet Explorer = 8.0.7600.16385
Microsoft .NET Framework = 2.0.50727.4971
Operating System = 6.1.7600
As I am having sql express 2008 Express version installed, my database size should have max 10GB size not 4GB.
Please help me...