Here is a tip that will speed up your updates and service packs for Microsoft Dynamics GP.
The SQL server is smart! It will lock and unlock records for you as needed. That’s all well and good, but what most people do not know is that if only one user is using a database, the SQL server automatically skips some locking and unlocking tasks which significantly speed up the process.
To upgrade as fast as possible, I recommend executing the following steps:
- Make sure SSRS is turned off.
- Make sure you or anyone else is not connected to the SQL server in any way, for any reason, for any application.
Want to learn more? Here’s what you can do:
By Shane LaBarge, CPA, MBS, MSIS, Dynamics GP Consultant, Avastone Technologies LLC,