Tip #3 - Filter in SQL Management Studio

Mark_BrummelMark_Brummel Posts: 4,262Member, Moderators Design Patterns
edited 2009-07-15 in SQL Tips & Tricks
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...


  • krikikriki Posts: 8,853Member, Moderator
    [Topic moved from 'NAV Tips & Tricks' forum to 'SQL Tips & Tricks' forum]
    Regards,Alain Krikilion
    Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
    NAV TechDays 2019: 21 & 22 November 2019, Antwerp (Belgium)
Sign In or Register to comment.