For those who tested the new SQL Server 2008, you probably got this message, when trying to change the columns in some tables, add columns or change nullity conditions. "Save is not permitted"... and something like tables have to be dropped and re-created. The only choice you have is to click cancel, or to choose to save the message to a text file, which is, i think, not very useful.
The solution i found today is in SQL Books Online, nd it is pretty easy:
The solution i found today is in SQL Books Online, nd it is pretty easy:
Tools -> Options -> Designers, and uncheck the option "Prevent saving changes that require table re-creation".
Posts
Thanks for help. SQL Server 2008 is very annoying. At first it took me 4-5 hours to install it (there were stupid checks and errors during install). Now this stupid option turned on by default. Why should I use SQL Server Management studio if I don't want to edit db? Microsoft where are you going?
ReplyDeleteThank u for this post
ReplyDeleteSreejesh