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.