Changing Company Name is very slow

elwin68

A customer of us wants to change the company name in Navision.
The change of a company name inside a native Navision database has a duration less then a minute.
When our customer is doing this with his SQL database the duration is more then 45 minutes. This is very long.
Does anyone know if this is normal and if this can be decreased?

Our customer works with Navision 3.70b and SQL 2000.

Thanks in advance.

ara3n

Yes this is normal. It takes a lot longer on sql than in native db.

Luc_VanDyck

Have a look at the SQL database structure, and you'll know why.

Does your customer plan to rename his company regularly?

DenSter

Tablenames on SQL Server include the company name, so when you rename a company on SQL Server, it has to rename all tables in the database. It depends on the SQL Server whether this takes a long time or not. I've seen this take 10 seconds, and I've seen this take more than an hour.

Make sure that you set the database to single user, and that you are on the server directly. If there's someone in the database while you're doing this it'll take forever.

The most annoying thing is that you can't see the progress while it's doing this, so you don't know if it's stuck or almost done.

Luc_VanDyck

DenSter wrote:

Tablenames on SQL Server include the company name, ...

Now you have spoiled all the fun for elwin ;-)

elwin68

Thanks for your answers.

Now I read the answer, the problem is clear to me.

Luckely the comapny name is not changed often.