Home > Relational Database, SQL Server2008 > SQL Server 2008 : Prevent Saving changes

SQL Server 2008 : Prevent Saving changes


Today I was working on a pet project and got this weird problem. I have worked with SQL Server 2005 but this is my first experience with SQL Server 2008. On the first very attempt with SQL Server I got this error from Visual Studio Management Studio.

SQLError-1

My change involves changing the column type from Nullable to Non-Nullable. So naturally SQL Server will have to drop the table and recreate the table. I understand.

But it is obvious that this message comes from Management Studio not from SQL Server. There must be some setting in Management Studio that does not allow me to do this change. I searched in the Tools  Options menu and aha I have struck gold.

SQLError2

Just uncheck “Prevent Saving changes that require table re-creation”. That’s it.
By the way, any good web3.0 project ideas for a asp.net pet project? Share with me

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: