SQL 2008 - Change ‘Edit Top 200 Rows"
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 dont have to, and its in very simple to do and find… But I have one of my dev’s point it out to me as I seemed to have been blind to this, even though I was looking for it for hours, and even went into the options console…
Lesson 1 learnt, late nights and SQL don’t mix.
Lesson 2 Change the Top 200 rows
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!
Cheers