Microsoft CRM 4.0 Change Custom Attribute Type from NVARCHAR to Float

Posted on 2012-09-07
Last Modified: 2012-09-11
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?
Question by:sbdt8631
    LVL 19

    Expert Comment

    by:Rikin Shah
    The second step specified in this solution may suit your needs-
    LVL 27

    Accepted Solution

    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.

    LVL 1

    Author Closing Comment

    Thank you

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Suggested Solutions

    Sorry for my English and Italian screenshots..... Problem: Every Year the number of E-Mails grow dramatically and the space that they take on Exchange Servers or .PST files, grow much more faster, once it was only text, now our E-Mail Archives …
    Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
    Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…

    779 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

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now