At a project I’m currently working on we recently moved from SQL Server 2005 to SQL Server 2008. The 2008 Management Studio has some nice new features, like intellisence for T-SQL but also some pretty annoying ones like:
- Select Top 1000 Rows and
- Edit Top 200 Rows
It’s good to know you can easily change these Top values in whatever you like.
To change the values just go to Tools | Options | SQL Server Object Explorer.

If you prefer the good old Select All Rows en Edit All Rows, fill in a zero.