Tip #3 - Filter in SQL Management Studio

Marije_BrummelMarije_Brummel OlstMember, Moderators Design Patterns Posts: 4,262
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 LondonMember, Moderator Posts: 9,045
    [Topic moved from 'NAV Tips & Tricks' forum to 'SQL Tips & Tricks' forum]
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Sign In or Register to comment.