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

Microsoft CRM 4.0 Change Custom Attribute Type from NVARCHAR to Float

I have some custom attributes that I created as nvarchar that I would like to change to float without deleting and recreating them.  I tried changing what appeared to be the applicable values in the Attribute table in my company database for one of the attributes as well as changing the data type in the QuoteExtensionBase table but that did not work.
Is there a "Back Door" method for doing this?
1 Solution
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
The second step specified in this solution may suit your needs-
Chinmay PatelEnterprise ArchitectCommented:
Hi sbdt8631,

It is not possible without deleting and recreating the field. Whatever back door you try make sure you know what you are getting into. You might end up unusable CRM database. Also know that these backdoors will support your CRM unsupported i.e. come tomorrow you run into a problem, if you have made changes to the database you might not be eligible to get support from Microsoft.

sbdt8631Author Commented:
Thank you

Featured Post

Receive 1:1 tech help

Solve your biggest tech problems alongside global tech experts with 1:1 help.

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