Thursday, October 30, 2008

SQL Server 2008 Designer Behavior Change: Saving Changes Not Permitted

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.
 
 
"This is by design and can be quickly fixed in Management Studio by unchecking a property. To fix this in Management Studio, go to Tools -> Options then go to the Designer Page and uncheck Prevent saving changes that require table re-creation."

Tuesday, October 21, 2008

New Date Data Types in Microsoft SQL Server 2008

Here's another good article article written by Scott Mitchell discussing the new date data types available in Microsoft SQL Server 2008.
 
"This article explores the time and date data types and shows how they can be used and formatted from within an ASP.NET page. This article also includes a short discussion on the datetime2 and datetimeoffset and compares and constrasts SQL Server 2008's six different date data types."
 
 
Scott Mitchell is the the editor, founder, and primary contributor to 4GuysFromRolla.com.