Well this is a great idea from Microsoft, but what if you want them all :twisted:, or you want more then 200 rows like me :twisted:, I am greedy :mrgreen:, I like everything….:razz:

Any ways I was prepared to hack the registry for this one :twisted:, but it seems you don’t really have to :razz: , and its in very simple to do and find…

Lesson 1 learned, late nights and SQL don’t mix.:lol:

Lesson 2  Change the Top 200 rows :shock:

go to:

Tools -> Options ->SQL Server Object Explorer, Expand this tree

Choose Commands

And there you go change it to your desired amount, 0 = everything! :cool:

This is the youtube link for my demonstration :cool: :

Best Regards.

Rabih Tawil