Too much objects for SQL Object Explorer

By | June 11, 2010

This is the first time it occured to me looking at a message on the SQL Object Explorer which says “See Object Explorer Details for objects in this folder”.  My first reaction is WTF I am in Object Explorer Explorer already.  For you to know what I am talking about here is the screenshot.

See Object Explorer Details

Now why does that happen? How will I see my tables? Do I just rely on T-SQL Scripts to manage the objects in my SQL Instance?


Now let me explain why it happens.  Object Explorer can only display up to a maximum of 65,536 objects and once you exceeded that limit you will see the message. To continue viewing the remaining objects in the Object Explorer you have to close the nodes that you are not using but if that does not help for expample you are opening the Tables section where in you have 100K+ tables in the database then apply filtering is the best way to reduce the number of objects shown in one time.  Now to do that is simple.  Just right click on the Folder Object you are in a choose filter.

Filter Settings

Which will bring you to a window which you can define your filter parameters.

Filter Properties

Im my example I chose all tables with the “test” on its name.

Filtered

Once filtered you will see a filtered tag beside the folder so it reminds you that the view you are using is filtered.

To remove the filter is simply going back to the Folder and right click remove filter.

Remove Filter

Now dont start asking me why the heck I have 65,536 tables in one database 🙂


4 thoughts on “Too much objects for SQL Object Explorer

Leave a Reply