Truemag

  • Categories
    • Tips And Tricks
    • Internet
    • PHP
    • Javascript
    • CSharp
    • SQL Server
    • Linux
  • Lastest Videos
  • Our Demos
  • About
  • Contact
  • Home
  • Write With Us
  • Job Request
Home SQL Server Save Table Structure Changes When Remote Access To SQL Server

Save Table Structure Changes When Remote Access To SQL Server

When remotely connect to SQL Server and edit structure/design of a particular table, it doesn’t allow you to save the changes although it works fine if connect directly to the database server.

It produces an error message:

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 be re-created or enabled the option Prevent saving changes that require the table to be re-created.

SQL Server Saving changes is not permitted

SQL Server Saving changes is not permitted

In order to deal with the issue, go to Tools => Options in the Microsoft SQL Server Management Studio or Microsoft SQL Server Management Studio Express.

SQL Server Prevent saving changes that require table re-creation

SQL Server Prevent saving changes that require table re-creation

Expand Designers => Table and Database Designers, un check Prevent saving changes that require table re-creation option.

Finally, click OK button.

Mar 2, 2012Hoan Huynh
Connect Remotely To MySQL or SQL Server Databases for Godaddy Hosting AccountJavascript Problem Set focus textbox on Firefox
You Might Also Like:
  • SQL SERVER How to import Text/CSV file into table
  • Export/Import Data From Local Database To Remote Database With MS SQL Server 2008
  • HTTP/ HTTPS Document, CGI-BIN And Access/ Error Logs On cPanel, Plesk And VirtualMin
  • PHP SSH To Remote Server And Execute Command
  • PHP Load And Save Facebook Friend List
  • PHP Load Facebook Albums And Save To MySQL Database
  • MSSQL Export A Table Data To CSV
  • MSSQL Split Function returns table data
  • Replace String With NText Or Text Data Type In MS SQL Server
  • Get Image Width Height With JQuery And JavaScript
Hoan Huynh

Hoan Huynh is the founder and head of 4rapiddev.com. Reach him at [email protected]

9 years ago SQL ServerMicrosoft SQL Server Management Studio, Microsoft SQL Server Management Studio Express227
0
GooglePlus
0
Facebook
0
Twitter
0
Digg
0
Delicious
0
Stumbleupon
0
Linkedin
0
Pinterest
Most Viewed
PHP Download Image Or File From URL
22,162 views
Notepad Plus Plus Compare Plugin
How To Install Compare Text Plugin In Notepad Plus Plus
20,040 views
Microsoft SQL Server 2008 Attach Remove Log
Delete, Shrink, Eliminate Transaction Log .LDF File
15,821 views
JQuery Allow only numeric characters or only alphabet characters in textbox
13,296 views
C# Read Json From URL And Parse/Deserialize Json
9,790 views
4 Rapid Development is a central page that is targeted at newbie and professional programmers, database administrators, system admin, web masters and bloggers.
Recent Posts
  • Installment Loans – Making Sense of Online Software
  • Apple Pay Casino Canada
  • Casinos austria
  • Essay For Sale – How To Write A Superb One That Will Sell
  • Free Online Photo Editor
Categories
  • CSharp (45)
  • Facebook Graph API (19)
  • Google API (7)
  • Internet (87)
  • iPhone XCode (8)
  • Javascript (35)
  • Linux (28)
  • MySQL (16)
  • PHP (84)
  • Problem Issue Error (29)
  • Resources (32)
  • SQL Server (25)
  • Timeline (5)
  • Tips And Tricks (141)
  • Uncategorized (103)
Recommended
  • Custom Software Development Company
  • Online Useful Tools
  • Premium Themes
  • VPS
2014 © 4 Rapid Development