• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1521
  • 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

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

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