Saving Changes in Table Design in SQL Server 2008

One of the new things that happens in SQL Server 2008 is that it prevents saving table structure changes that require the table to be dropped and re-created. While this is a great feature to prevent accidents from occurring, on a developer machine it can be quite frustrating. This is the dialog you get when trying to make changes in a table design.

image

Unfortunately, this dialog doesn’t tell you where to turn this feature off! Clicking on the small “?” on the title bar does get you to a help page that tells you how to do it.

Anyway, the place to do it is Tools > Options > Designers > Table and Database Designers > Prevent saving changes that require table re-creation. Turn this option off and you will be able to save the tables again.

image


Tags: , ,
Categories: SQL Server | Tips | Development

Posted by vinod on September 24, 2008 00:37 2 Comments
Actions: E-mail | Permalink | Comment RSSRSS comment feed

Related posts

Comments

January 3. 2009 05:59

Prakash

Hi....
This is great now I can change in table defination.

Thanks

Prakash

January 3. 2009 17:46

Sam

Thanks for the tip! I was going to be disappointed with SQL Server's direction if I had to drop a table to add a few characters to a column. It was a reminder of my frustrations with Oracle!

Sam

Add comment


(Will show your Gravatar icon)  

  Country flag

[b][/b] - [i][/i] - [u][/u]- [quote][/quote]



Live preview

January 6. 2009 19:24