In the below site it says that there is no limit on the size but Iam still getting the problem
http://www.microsoft.com/downloads/details.aspx?familyid=6931fa7f-c094-49a2-a050-2d07993566ec&displaylang=en
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx
Pls can any one help me.
Alter failed for database 'test'. (Microsoft.SqlServer.Smo)
An exception occured while executing a Transact-SQL statement or batch(Microsoft.SqlServer.ConnectionInfo)
Create DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096MB per database (Microsoft SQL Server, Error:1827)Seems that you instaleld SQL Server Express edition. The limitation mentioned applies to this edition. Run the SELECT @.@.VERSION on the machine you are using command.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||I did run select @.@.version on my machine, please find below the result of it
Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86) Oct 14 2005 00:33:37 Copyright (c) 1988-2005 Microsoft Corporation Express Edition on Windows NT 5.0 (Build 2195: Service Pack 4)
Please help
|||Hi,
so you either did not have Enterprise edition installed, or connected to the wrong instance.
HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment