Psst… if you looking to learn more about LINQ, ASP.NET 3.5, Silverlight 2 or SQL Server 2008, check out this website where you can download the books for free.
In SQL Server 2008, when you do some changes on a table and save it you’ll get a warning message like below
Saving changes is not permitted. The changes you have made require the following tables 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 the… that didn’t happen to me in SQL Server 2005 nor previous versions of SQL Server. So there is definitely a behaviour change in the new management studio. Luckily this behaviour can be disabled, which I found it in Brian Knight’s blog here. You just need to go to Tools -> Options then go to the Designer Page and uncheck "Prevent saving changes that require table re-creation".
Four Malaysian technical communities, Intel IT Technical Community Malaysia Chapter .NET SIG, ELITE, MIND and SPAN, are coming together to host a community event focusing on technical dives of Microsoft Windows Server 2008â„¢, Visual Studio 2008â„¢, and SQL Server 2008â„¢.
Date : 28 June 2008, Saturday
Venue : Microsoft Auditorium
Microsoft (Malaysia) Sdn Bhd
Level 29, Tower 2,
Petronas Twin Tower, KL
My dear ‘ka ki lang’ in Penang, Microsoft is doing a community launch of Windows Server 2008, SQL Server 2008 and Visual Studio 2008 at Intel’s PG12 auditorium tomorrow from 8.30am – 5.30pm.
More info here