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.
Tag Archives: Database
How To Use PowerShell To Refresh A Microsoft Dynamics Business Central On Premises Test Database
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.
Search an entire NAV database with 10 lines of code
So a friend and I talked about how to search for data in NAV across all tables, and I said, I can do that in 10 lines of code.
Database Replication – Part III
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.
Database Replication – Part II
This post is in continuation to my earlier post. Please check if you missed.
As committed in this post we will cover practical approach.
Database Replication – Part I
One of my reader had requested to write post on this topic. I have gone through some posts and prepared a step by step process to demonstrate how we can configure Database Replication in SQL.
How to connect SQL Server Management Studio to the NAV 2018 database on Docker?
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.”