Terranet Technologies  Welcome to TNet   Sign Up  Login 
           
HomeDevelopmentConsultingSolutionsUsersSupport
zip:
Weather in Tulsa, OK (74133)
Current Conditions:
Fair 77°F
Fair
Wind: CALM calm mph
SAT
9/4
Sunny
H:85
L:55
SUN
9/5
Sunny
H:89
L:64
MON
9/6
Sunny / Wind
H:93
L:69
TUE
9/7
Scattered T-Storms
H:87
L:68

Last Update: 4:53:39 PM
weather.com

Services
ASP.Net
C#
VB
TSQL
   

Welcome to Terranet Technologies forum.  This is a private Web Service so it will require you to create a seperate account other than your Terranet account.   Please use your existing Terranet user name.  It will only require your email and a password to join.

Join | Logon
 All Threads | New ThreadView:  Search:  
 Author  Thread: SQL Server 2008 Options
codeking
Posts: 4
SQL Server 2008 Options
Posted: 11 Mar 09 9:08 AM
I am having trouble with SQL Server 2008. WHen ever I try to change a database add unique key, change from NULL to NOT NULL. I get the error telling me:

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.

I cant find these options . Please help!!!
[Reply][Quote]
sharpcoder
Posts: 2
Re: SQL Server 2008 Options
Posted: 11 Mar 09 10:37 AM
To disable this feature in SQL Server 2008 Management Studio, navigate to Tools | Options | Designers | Table and Database Designers and uncheck the Prevent saving changes that require table re-creation checkbox.


[Reply][Quote]
 Page 1 of 1 

Copyright© 1998 - 2010 Terranet Technologies LLC All rights reserved.