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
Go to http://dynamicsuser.net/blogs/mark_brum ... tudio.aspx
for the rest with images...