Today, I would like to briefly talk about how to view Database Locks in Business Central. I ran into this problem recently when I was testing standard events, so I wanted to share it in the hope that it will help you.
This article is only for on-premise installations of Business Central (BC). The cloud/SaaS version requires a completely different method of refreshing involving Sandboxes. The steps below might also work for older versions of NAV, but I have not done any regression testing.
We will configure distribution at the Publisher and set the required permissions on the publication and distribution databases. If you have already configured the Distributor, you must first disable publishing and distribution before you begin this process. Do not do this if you must retain an existing replication topology.
Recently someone asked me how to connect SQL Server Management Studio to the database on a Docker image for NAV 2018. Before I could answer Jakub Vaňák already did and said: “Of course it is. If you want to access the default instance inside one of MS NAV containers you can access it from your docker host machine providing the name of your container.”