Brief googling and I I found the solution:
On SQL server Management Studio go to Tools–>Options->Designers and un check the option "Prevent saing changes that requires table re-creation"
Done!
Tuesday, January 20, 2015
Prevent saving changes that require table re-creation
Today I was trying to change the structure of a table in SQL server and I could'n! I got the error: "Saving changes is not permitted" !
Brief googling and I I found the solution:
On SQL server Management Studio go to Tools–>Options->Designers and un check the option "Prevent saing changes that requires table re-creation"
Done!
Brief googling and I I found the solution:
On SQL server Management Studio go to Tools–>Options->Designers and un check the option "Prevent saing changes that requires table re-creation"
Done!
Subscribe to:
Post Comments (Atom)
-
Hi I just got this error code on the Samsung ML5010-ND: This was a toner problem. Toner is not evenly distributed. Solution: Remove ... -
Frustrating! SQL Server 2014 - 64 Bit My dtsx package works fine if run manually but no way to schedule it on SQL Server Agent. Solution... -
Hi I added the "Search" gadget to my blog, and it doesn't work ....
This comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDeleteThis comment has been removed by a blog administrator.
ReplyDelete