SQL Server 2008 - Saving changes is not permitted

Want to design a table using SQL Server 2008? Well get ready to reach for Google to find out where the hidden setting is. The SQL team wouldn't want to tell you where the setting is in their large dialog box that basically says "computer says no", that would be far to easy. Tools -> Options -> Designers -> Tables and designers -> Uncheck the option: "Prevent saving changes that require table re-creation". References: http://www.henrycordes.nl/post/2008/11/Saving-changes-is-not-permitted-(SQL-Server-2008).aspx

Comments

Post a Comment

Popular posts from this blog

PHP timezones explained

--------------------- PHP timezones example written by Simon Hutchison - http://www.econfirm.com.au/ --------------------- date_default_timezone_set("Australia/Sydney") Sun, 02 Mar 2008 14:57:11 +1100 date_default_timezone_set("Australia/Perth") Sun, 02 Mar 2008 12:57:11 +0900 --------------------- The comments in this example assumes server is Sydney time. --------------------- Demonstrating that timezone is not important for mktime(), date("U") and time(). Get GMT 0. Uses the server time to adjust to GMT 0 so need to ensure server time is correct for these functions to be accurate. date_default_timezone_set("Australia/Perth") mktime() : 1204430231 date("u") : 1204430231 time() : 1204430231 date_default_timezone_set("Australia/Sydney") mktime() : 1204430231 date("u") : 1204430231 time() : 1204430231 --------------------- Now that we know this we can use these functions to compare to other GMT 0 adjuste...
Read more

iPhone Internet Tethering settings

iPhone Internet Tethering settings. For newer iPhones it should there already under: Settings->General->Network->Internet Tethering. If it's not there then go to this link: http://help.benm.at/help.php (on your iphone). Select on mobileconfigs which goes to here: http://help.benm.at/tethering.php Select Australia (or whatever country you are in) which goes here: http://help.benm.at/au.php Pick your provider.
Read more