Sql Server Saving changes is not permitted error Prevent saving changes that require table re-creation

0 votes

If I try to change a column type from int to real after creating and saving a table in SQL Server, I receive the following error:

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

Why do I need to make the table again? I simply want to convert a smallint data type to real.

I haven't used the table until now, therefore it is empty.

Sep 4 in Database by Kithuzzz
• 12,240 points
10 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Database

0 votes
0 answers

SQL Server database restore error: specified cast is not valid. (SqlManagerUI)

For my production website, SQL Server 2008 ...READ MORE

Aug 20 in Database by Kithuzzz
• 12,240 points
66 views
0 votes
1 answer

Login failed for user 'sa'. The user is not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452) in sql 2008

Solution Go to Start > Programs > Microsoft SQL Server > Enterprise Manager. Right-click the SQL ...READ MORE

answered Sep 12 in Database by narikkadan
• 20,880 points
39 views
0 votes
0 answers

Why is SQL Server Agent not starting?

On top of Windows Server 2012, I ...READ MORE

Aug 9 in Database by Kithuzzz
• 12,240 points
19 views
0 votes
0 answers

What is the difference between drop table and delete table in SQL Server?

What is the distinction between the following ...READ MORE

Aug 9 in Database by Kithuzzz
• 12,240 points
71 views
0 votes
0 answers

How to find server name of SQL Server Management Studio

Microsoft SQL Server 2008 is now installed. ...READ MORE

Sep 6 in Database by Kithuzzz
• 12,240 points
12 views
0 votes
1 answer

DateTime serialization best practices in .NET 3.5

One of the best ways to do ...READ MORE

answered Dec 17, 2018 in Database by DataKing99
• 8,240 points
371 views
0 votes
1 answer

How to delete duplicate rows in SQL Server?

To answer your query, note that CTEs ...READ MORE

answered Feb 10 in Others by Soham
• 9,330 points
196 views
0 votes
1 answer

Rename column SQL Server 2008

Use sp_rename EXEC sp_RENAME 'TableName.PreviousColumnName' , 'NewColumnName', 'COLUMN' See: SQL SERVER ...READ MORE

answered Feb 23 in Database by Vaani
• 7,020 points
53 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP