[SQL Server] Saving changes is not permitted

SQL设置教程：允许修改表后保存更改
最新推荐文章于 2024-07-04 14:55:17 发布
原创 最新推荐文章于 2024-07-04 14:55:17 发布 · 390 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#SQL Server

本文提供了一步指南，说明如何在Microsoft SQL Server Management Studio 2008中调整设置，以允许在修改表后进行保存。遵循步骤，确保在执行必要的表重建操作前能够保存更改。

To allow you to save changes after you alter table, Please follow these steps for your sql setting:

  1. Open Microsoft SQL Server Management Studio 2008
  2. Click Tools menu options, then click Options
  3. Select Designers
  4. Uncheck "prevent saving changes that require table re-creation" option
  5. Click OK
  6. Try to alter your table
  7. Your changes will performed as desired

     
2023-02-08 InnoDB Architecture
悟世之路
02-08 469
InnoDB Architecture。
haproxy 官方文档
热门推荐
zhaoyangjian724的专栏
09-24 1万+
HAProxy Configuration Manual version 1.5-dev24 willy tarreau 2014/04/26This document covers the configuration language as implemented in the version specified above. It does n
【转】 SQL2008修改表结构的时候弹出的提示Saving changes is not permitted.
我想我是海 冬天的大海 心情随风轻摆
05-06 756
<br />Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.You have either made changes to a table that can't re-created or enabled the option Prevent saving changes that require the table to
SQL2008 Saving changes is not permitted. （修改表时无法保存）
我想我是海 冬天的大海 心情随风轻摆
06-27 2858
弹出如下信息. Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.You have either made changes to a table that cant re-created or enabled th
【SQL】提示：saving changes is not permitted
weixin_43041350的博客
11-15 1009
2. 选择Tools–>Options–>Designers–>Table and Database Designers ,去掉Prevent saving changes that require table re-creation .数据库提示：saving changes is not permitted。1.回到SQL Server Studio(SSMS)首页。不要捉急，这是因为你设置了保存修改时重建表（一般是默认的）修改数据库表的时候，无法选择保存，
Saving changes is not permitted.
ustcyb的专栏
10-15 3325
最近要研究Reporting Services便给自己装了MSSQL2008企业版, 正版的哦~~~ 安装的时候要卸载原来的SQL2005 Express Studio. 自然新的SQL Server Management Studio 2008被安装上了. 由于项目经常要修改表结构,没办法,地球上的IT人都知道表结构不能随便修改, 但量客户那头有一个不是程序的程序员,只会简单的拖和拽和控件
MySQL运维DBA-MySQL8数据备份和恢复-006篇-mysqldump man帮助手册
老韩的Linux云计算架构师进阶之路
02-27 896
MySQL8数据备份和恢复-001-mysqldump man帮助手册。
Oracle Database 12c SQL Fundamentals I Exam Guide Exam 1Z0-061 学习笔记
tavor的专栏
07-13 3247
I. any arithmatic operator with null will result null   concate null will not result in null, will remain the same without nullII, for ' in literal value, could use '' to escape the it.    or could us
Zabbix企业级监控系统
2401_83784774的博客
07-04 906
案列：自定义监控客户端服务器登录的人数需求：限制登录人数不超过 1 个，超过 1 个就发出报警信息1点击左边菜单栏【配置】中的【模板】，点击【创建模板】【模板名称】设置成 Template Login User【可见的名称】设置成 Template Login User【群组】选择 Template【描述】可自定义点击 【添加】，此时就可在【名称】中搜索到 Template Login User 了先明确获取监控指标数据的命令或脚本。
T-SQL Part VI: Prevent error message "Saving changes is not permitted" in SSMS
Wrote Ideas Down, Together with Skills
06-02 783
使用SSMS时，经常遇到的问题是，修改一张table时，弹出一个错误对话框：“Saving changes is not permitted”。这个错误通常是因为以下错误（参阅MSDN的KB文档 https://support.microsoft.com/en-us/kb/956176） You change the Allow Nulls setting for a column. 修改了一个Co
Sql Server 'Saving changes is not permitted' error Prevent saving changes that require table re-cr
u011407962的博客
06-09 658
Saving changes is not permitted. The change you have made requires the following table to be dropped and re-created. You have either made changes to a table that can't be recreated or enabled the op
SQL Server - saving changes is not permitted
A_bad_horse的专栏
12-11 263
SQL Server - saving changes is not permitted
SQL Server - Saving changes is not permitted
10-20 958
If you get the following error message when you re-design the table and couldn't save it: Saving changes is not permitted. The change you have made requires the following table to be dropped and
MSSQL的“Saving changes is not permitted...”处理方法
在南极与企鹅共舞！
10-25 751
"Saving changes is not permitted"
Saving changes is not permitted. （修改表时无法保存）
weixin_41579911的博客
06-16 838
弹出如下信息. Saving changes is not permitted. The changes you have made require the following tables to be dropped and re-created.You have either made changes to a table that can't re-created or enabled t...
SQL Server Error: Saving Changes is not permitted. The changes you have made require the following t
yandao的博客
01-12 679
问题 修改数据库表的时候，无法选择保存，提示：saving changes is not permitted,如下图 解决方案 Open SQL Server Management Studio From the file menu, choose Tools à Options From the left menu, choose Designers Uncheck the box entitled Prevent saving changes that require table re-creati
Saving changes is not permitted. The changes that you have made require the following tables to be d
hbu_pig的专栏
05-17 2584
Saving changes is not permitted. The changes that you have made require the following tables to be dropped and re-created. ERROR: “Saving changes is not permitted. The changes that you have made req
saving changes is not permitted.The changes you have made require the following tables to...
学者-微风
09-24 1161
修改数据库时，提示： saving changes is not permitted.The changes you have made require the following tables to be dropd 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 tabl
extern is not permitted on a declaration
最新发布
08-08
在编程中，使用 `extern` 关键字时可能会遇到 **“extern keyword not allowed in declaration”** 的错误。这种错误通常出现在以下几种情况下： ### 原因分析 1. **错误地在变量定义中使用 `extern`** `extern`...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值