Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

MSSQLServer 2014 Difficult Schema change

Posted on 2017-11-14
2
Medium Priority
?
23 Views
Last Modified: 2017-11-14
I have a small MSSQL Server 2014 table with no records in it and wish to change an integer column to an identity column.
when I attempt to do so in the table Design window, I get an error as shown in the following image

If I copy the table to an MSSQL Server 2005 database I can change the column to an identity column without any error message and copy the table back to the MSSQL Server 2014 database and the change has been made.

In both cases I am logged in to the database as sa (system administrator) with all rights.
What is the problem with MSSQLServer 2014 ?


SQL Serve 2014 Error message
0
Comment
Question by:alcindor
  • 2
2 Comments
 
LVL 2

Accepted Solution

by:
alcindor earned 0 total points
ID: 42368433
I have discovered how to disable the option and fix the problem:
Change this option, on the Tools menu,
click Options, expand Designers,
and then click Table and Database Designers. Select or clear the
 "Prevent saving changes that require the table to be re-created" check box.

This was found on the following site:
Stack Overflow link
0
 
LVL 2

Author Closing Comment

by:alcindor
ID: 42368436
Discovered how to disable the option that was causing the problem
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Join & Write a Comment

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

783 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question