July 7, 2008 at 1:34 pm
Trying to attach a DB that contains partitoned tables - receiving error msg:
Database cannot be started in this edition of SQL Server 2005 because it contains a partition function. Only Enterprise edition of SQL Server 2005 supports partitioning.
Yes, I only have STANDARD edition of SQL 2005 installed. (9.00.3054)
Of the 4 editions available to me: Express, Workgroup, Standard, and Enterprise ---
1) Is Enterprise the only edition which supports partitioning?
2) Can I install Enterprise on my desktop?
July 7, 2008 at 1:46 pm
DBASkippack (7/7/2008)
Trying to attach a DB that contains partitoned tables - receiving error msg:Database cannot be started in this edition of SQL Server 2005 because it contains a partition function. Only Enterprise edition of SQL Server 2005 supports partitioning.
Yes, I only have STANDARD edition of SQL 2005 installed. (9.00.3054)
Of the 4 editions available to me: Express, Workgroup, Standard, and Enterprise ---
1) Is Enterprise the only edition which supports partitioning?
2) Can I install Enterprise on my desktop?
1. From BOL: http://msdn.microsoft.com/en-us/library/ms143761.aspx?n=0
Yes only EE
2. You should use DEVELOPER Edition which "supports" EE "features" with hardware limitations....
* Noel
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply