So I’ve just started using MS SQL Server 2008 (yes, I’m that far behind) cause we received it on our Microsoft subscription now, so it was time to test and play 
My first impression was that it was annoying they changed “Open” into both an Open Top 1000 rows and Edit Top 200 rows. Mostly because when I open a table, I like to open the entire table – just a preference of mine. Of course this is made to avoid having to wait a long time to open and edit a table if it contains a lot of rows, but in my work it was a constraint.
Luckily – this could be changed easily, by going into Tools -> SQL Server Object Explorer -> Commands and you can enter a 0 for all rows, if you want that – or another number to keep it at Open Top <n> rows.
Glad I didn’t have to mess with the registry for this.
The second problem I ran into was the error message: “Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created” and so on…… Luckily Microsoft thought of us again and this was also easily changeable.
So once more into the Tools menu: Tools -> Options -> Designer -> Prevent saving changes that require table re-creation” and uncheck that.
