SQL Server 2008 Management Studio – Saving changes is not permitted error.

We’ve recently upgraded our development laptops with SQL 2008 from SQL 2005. Today I was trying to create a new database for a client within the management studio and every time I decided, for example, to change a column that was defined nullable to not nullable and tried saving my design, which in turn would save the table changes, it gave me the following error:

Now, I understand the need for potentially re-creating the table if for example you had an existing table where a column was nullable and it contained data then you wanted to make it not nullable (without a default value) it would correctly so moan. But you would think that the Microsoft devs would build a system intuitive enough to know that where there isn’t any data in the table yet, because you’re designing the schema, it could automatically drop and re-create the table and any associated relationships.

Needless to say, to prevent this from happening to you – go into the Tools -> Options and click on the Designers item in the tree menu on the left and make sure “Prevent saving changes that require table re-creation” is not ticked as below:

Hope that helps someone else too!

Come on summer, come on!

If the weather we had this weekend was any indication of what our summer is going to be like, it’s going to be hot!

We had our company braai this Saturday out in Tokai and it was a very enjoyable event. Everyone brought their partners/spouses along and those that had kids brought them too. We had a great braai, with some very, very tasty lamb-chops and boerewors. The kids thoroughly enjoyed swimming in the pool (very refreshing after standing in-front of a hot fire in the sun), while some of the others played cricket and threw frisbees around.

Sunday we had my brother and his wife together with our parents over for lunch to celebrate my dad’s 63rd birthday this past week. The weather looked a bit daunting in the morning but it cleared up nicely in the afternoon. While the kids played outside on their new jungle gym we played some friendly Texas Hold’em. Why is it when you bring a new player into the game, they inevitably end up cleaning everyone out? 🙂

All in all, a great weekend, nice and relaxing – now back to the grindstone for the week ahead!