Cannot create companies in Business Central OnPrem

Kristof163
Kristof163 Member Posts: 2
in NAV Three Tier
Dear all,

We have BC 19 Spring Edition on a SQL Server 2019 standard edition.

When I want to create a company or copy a company I get the following error: "Online index operations can only be performed in Enterprise Edition of SQL Server".

Is there a way I can disable Online Index operations? Or do I have to upgrade to SQL Server 2019 Enterprise ?

Kind regards,

Kristof

Comments

  • SanderDk
    SanderDk Member Posts: 507
    HI @Kristof163
    This is not a BC error, this is related to your SQL server.
    You must have a trigger/Event on your SQL server that create a index when you SQL schema is changing.

    You need to location the piece of logic on your SQL instance and either disable it or wrap the T-SQL in IF SERVERPROPERTY XXXX

    You should be able to and extra companies in BC
    For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.

Categories