Tip #3 – Filter in SQL Management Studio

This Blog Article was brought forward from my old blog

This time another tip on how to use the SQL Management Studio.

Dynamics NAV (Navision) keeps a copy of all tables on SQL server for each company you create, no matter if the table is populated or not. This way of creating tables can lead to a long list of tables in the SQL Management Studio.

Expanding the table tree can even take minutes on heavy used systems. How to avoid that.

Step 1. Go to the SQL Management Studio, connect to the server and expand the database you want to use

Step 2, right click on the table or view secion and choose filter.

Step 3 – Apply the filter

Remember that it is automaticaly a part of the filter, not an exact match

And Voila