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 ... -
Dear All I was looking for a good online backup free space. I am currently using an account of Mega, one of Drive, Dropbox ... OneDrive bu...
-
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...
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