Well this is a great idea from Microsoft, but what if you want them all , or you want more then 200 rows like me , I am greedy , I like everything….
Any ways I was prepared to hack the registry for this one , but it seems you don’t really have to , and its in very simple to do and find…
Lesson 1 learned, late nights and SQL don’t mix.
Lesson 2 Change the Top 200 rows
Tools -> Options ->SQL Server Object Explorer, Expand this tree
And there you go change it to your desired amount, 0 = everything!
This is the youtube link for my demonstration :