Post reply

ALTER PARTITION FUNCTION fails to execute after upgrade

  • March 11, 2009 at 7:43 am

    #201234

    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

    #957611

    As per http://www.microsoft.com/Sqlserver/2005/en/us/compare-features.aspx it is only available in the Enterprise version....

    _______________________________________________________________________
    For better assistance in answering your questions, click here[/url]

  • March 11, 2009 at 3:10 pm

    #957924

    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