March 11, 2009 at 7:43 am
After I Upgraded my database server from Work group Edition to Standard Edition of SQL Server 2005 I see this message,
Cannot alter the partition function 'Function_Name', because it does not exist or you do not have permission.
This was working fine in SQL Server 2005 Work Group Edition. To What I understand is Standard Edition should have more features than Work group Edition.
According to Microsoft, Partioning is only available in SQL Server 2005 Enterprise Edition.
I cannot physically access that database server, I do not have permission to check what user is executing and if this function exists in the database ?
Question : ALTER PARTITION FUNCTION, is this feature available only in Enterprise Edition ? also please clarify what exactly this command does ?
Any website link would help.
Thanks,
IM.
March 11, 2009 at 9:46 am
As per http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx it is only available in the Enterprise version....
March 11, 2009 at 3:10 pm
I Understand Partitioning Function is only available in Enterprise Edition, Then how come my application was able to use this feature when I had my database server on Work Group Edition.
My Guess is ALTER PARTITION FUNCTION is not same as partitioning,
Any one please confirm
Thanks,
IM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply