SQL 2008 - Change ‘Edit Top 200 Rows"

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 don’t 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