September 2011

You are currently browsing the monthly archive for September 2011.

Here’s another silly one but it catches me every time.  So I decided to write a quick post about it, to never forget about it again!

Ever seen this warning message while using the Management Studio?

Warning: Saving changes is not permitted

All I did was open the AdventureWorks.Production.Product table in the designer, moved the ListPrice column above the StandardCost column and hit CTRL+S to save changes.  Instead of changing the table, it tells me:

Saving changes is not permitted.  The changes you have made require the following tabled to be dropped and re-created.  You have either made changes to a table that can’t be re-created or enabled the option Prevent saving changes that require the table to be re-created.

What a message huh?!  It needs to re-create the table, so what, go ahead!  Hang on, even though this is just a Warning, there’s no Continue button!  Ow come on, are you kidding?

Like any good developer that wants to get some work done, you stop reading such a long message after the second line and try to find a solution for your problem.  Too bad, you should have just continued reading the warning message because the solution is actually hidden in there!

If you open up the Options screen from the Tools menu in SSMS, and then drill down to the Designers > Table and Database Designers node, you’ll see an option called Prevent saving changes that require table re-creation.  And by default, that option is checked.  Remove the check from that box and you’ll be able to use the table designer as it was intended.

The "Prevent saving changes that require table re-creation" setting

So, here’s your ADSOTD (Annoying Default Setting Of The Day)!

Small note: be careful when you want to use this feature on a large table.  The script that gets generated in the background to make the changes needs to copy all records from the old table into the new one and that will obviously require some time!

Have fun!

Valentino.

Share

Tags: , ,

SQL Server DaysRemember last year’s SQL Server Day?  What, you didn’t make it due to the weather?  Come on, the snow wasn’t that bad?!

Okay, maybe it was if you didn’t have winter tires.  Well, good news!  To avoid that problem, we’ve decided to schedule our precious event two weeks earlier!

And because we know you like watching presentations by top speakers, we’ve also decided to make it two days instead of just one!  More precisely, November 14th-15th.

We’ve managed to get top speakers who’ll sound very familiar to you such as (in no particular order): Kevin Kline, Lubor Kollar, Chris Webb, Dandy Weyn, Jen Stirrup, …!

If that did not convince you, have a look at the agenda and list of sessions, available online.  We’re currently still in the process of adding sessions and speakers, but it surely gives you a good idea of what we have in mind.  Check it out on www.sqlserverdays.be!

On the other hand, if you are already convinced, be one of the first to register!  That’s right, registration is open since yesterday!

And that’s not all, until the end of the month you can take advantage of an early bird discount offer and pay only €79.  Beginning October 1st, that goes up to €99.   Which obviously is still peanuts for what you’ll be getting!

Hopefully see you there?

Valentino.

Share

Tags: ,

During the whole month of September, Packt Publishing will be offering a discount on their SQL Server, SharePoint and Silverlight book collection, divided in three “10 Days Of …”.

Here are the details:

10 days of SQL Server : 1st – 10th September

10 days of SharePoint :11th – 20th September

10 days of Silverlight : 21st – 30th September

Throughout these dates there will be up to 20% off SQL Server, SharePoint and Silverlight books and 30% off eBooks – for further information visit: http://www.packtpub.com/packt-10-days-of-sql-server-silverlight-sharepoint

In case you have read my previous post, you know that there’s one book that I can surely recommend: Microsoft SQL Server 2008 R2 Master Data Services!

As you’ve probably noticed, the first 10 days have already started, so hurry up, get yourself some reading material to get through the coming Winter (or Summer if you’re living on the Southern Hemisphere)!

Valentino.

Share

© 2008-2017 BI: Beer Intelligence? All Rights Reserved