• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1539
  • Last Modified:

Cannot change data types in SQL Server 2008

I need to change a column from Real to Money, but when I try to do so I get the message:-

Saving changes is not permitted. The changes you have made require the followilg tables to be dropped and re-created. You have either made changes to a table that can't be recreated or enables the option Prevent Saving Changes that require the table to be re-created
0
grwallace
Asked:
grwallace
1 Solution
 
chapmandewCommented:
try this instead (through tsql)

alter table tablename
alter column yourcolumnname MONEY

0
 
grwallaceAuthor Commented:
Perfect - Thanks
0
 
adurveCommented:
u r great man I got lots of ans like modify and all different but just ur work fine thanks a lot  
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now