Author Archives: Tomas

How to find the size of Dynamics NAV database in SQL Server Management Studio?

I have shown you, how easy it is to find the size of the database from Dynamics NAV client. However sometimes you need to get the same information without the luxury of running Dynamics NAV client. For this, you can … Continue reading

Posted in Dynamics NAV / Navision, SQL | Tagged , , , , , | Leave a comment

How to find the size of Dynamics NAV database?

How to find the size of Dynamics NAV database? This should be quite easy, right? Well, all you need to do, is to go to File > Database > Information: and in “Database” tab, you will see the field Database … Continue reading

Posted in databases, Dynamics NAV / Navision | Tagged , , , , | 1 Comment

Connect to Dynamics NAV database with one click (Desktop Shortcut)

If you are using mostly RoleTailored Dynamics NAV client, then this tip will not be that helpful. If, however, you are like me, and you are still use Dynamics NAV Classic client a lot, then you will love┬áthis tip! A … Continue reading

Posted in Dynamics NAV / Navision, functionality | Tagged , , , | 4 Comments

Error: You cannot use the file TEMP because it is already in use

You are working in Dynamics NAV, creating your sales orders, and… you were kicked out from the server (getting error message: You cannot use the file TEMP because it is already in use). OK, let’s try to replicate the issue. … Continue reading

Posted in Dynamics NAV / Navision, errors | Tagged , , | Leave a comment

How to clear Change Log Entry table from SQL?

In my previous article about Change Log, I have explained how to clear Change Lot Entry table from Dynamics NAV. However, I also mentioned, that when clearing entries from Dynamics NAV, system is deleting only one change log entry at … Continue reading

Posted in Dynamics NAV / Navision, SQL | Tagged , | Leave a comment

My posted sales invoice is missing from Dynamics NAV!

If you go to Sales & Marketing > History > Posted Invoices, and search for invoice by filtering in “Order No.” sometimes you might not find any invoices. There are two possible reasons for that – 1. (Quite common one) … Continue reading

Posted in Dynamics NAV / Navision, functionality | Tagged , , , , | 4 Comments

How to clear Change Log table?

There are a few tables that can become really big in Dynamics NAV. It is expected for our Ledger Entries to grow as time passes, but, quite often I hear people saying about Change Log Entries table is growing out … Continue reading

Posted in Dynamics NAV / Navision, functionality | Tagged , , | 1 Comment