ALTER PARTITION FUNCTION fails to execute after upgrade

  • 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.

  • 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]

  • 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