如何在Management Studio 2008R2中设置设置 [英] How to set the setting in Management Studio 2008R2

问题描述

我已经在该表中创建了一些数据，之后我更改了设计:我得到了
这个错误.如何设置Management Studio 2008R2的设置


我收到此错误

不允许保存更改.您所做的更改需要下表
删除并重新创建.您对表所做的更改都不能更改
重新创建或启用该选项可防止保存需要重新创建表的更改.

i was already created table this table some data after that i change the desing: i got
this error. how set the settings Management studio 2008R2


I got this Error

Saving changes is not permitted. The changes you have made require the following table
to be droped 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 re-created

推荐答案

您应该在Google上搜索错误消息.

http://support.microsoft.com/kb/956176 [ 1.打开SQL Server Management Studio(SSMS).
2.在工具"菜单上，单击选项".
3.在选项"窗口的导航窗格中，单击设计器".
4.选中或清除阻止保存需要重新创建表的更改"复选框，然后单击确定".

You should have googled with the error message.

LMGTFY[^]

The first link itself gives the answer:

http://support.microsoft.com/kb/956176[^]

To change the Prevent saving changes that require the table re-creation option, follow these steps:
1.Open SQL Server Management Studio (SSMS).
2.On the Tools menu, click Options.
3.In the navigation pane of the Options window, click Designers.
4.Select or clear the Prevent saving changes that require the table re-creation check box, and then click OK.

在SQL Server 2008中，如果要更改某些内容，则必须仅使用SQL查询.乍一看，似乎可以在GUI上执行，但不能执行.

in SQL Server 2008, if you want to change something then you have to do with SQL query only. At first sight it seems visible that we can perform on GUI, but we can''t do that.

这篇关于如何在Management Studio 2008R2中设置设置的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！