locked
Enterprise edition guid's doubt RRS feed

  • Question

  • we have installed crm enterprise edition

    i have a doubts regarding guid's generate

    will the crm genereted account/case guid's unique through out the organizations or only unique in a particular organization


    Wednesday, February 24, 2010 6:58 AM

Answers

  • Yes i do :).

    Read this

    The primary purpose of the GUID is to have a totally unique number. Ideally, a GUID will never be generated twice by any computer or group of computers on the face of the planet. The total number of unique keys (2<sup>128</sup> or 3.4×10<sup>38</sup>) is so large that the probability of the same number being generated twice is extremely small, and certain techniques have been developed to help ensure that numbers are not duplicated. (See Algorithm)

    http://en.wikipedia.org/wiki/Globally_Unique_Identifier

    It claims to be on the planet :). So As i said, its seems impossible :)
    Muhammad Ali Khan
    My MS CRM Blog
    • Proposed as answer by Muhammad Ali Khan Wednesday, February 24, 2010 7:46 AM
    • Marked as answer by VarunKumar17 Wednesday, February 24, 2010 7:49 AM
    Wednesday, February 24, 2010 7:45 AM

All replies

  • Guid are unique, independent of MS CRM, organization.
    These Guid stands for Global Unique Identifier.
    It means they will be unqiue on any system, in any application.
    So you don't have to worry about its uniquness in CRM since this feature is provided by SQL server database (with uniqueidentifier) field.

    A GUID represents a Unique identifier - means you cannot generate the same GUID
    more than once. A GUID has a very low (...practically impossible) probability of being duplicated




    see these for more details.
    http://www.webopedia.com/TERM/G/GUID.html
    http://searchcio-midmarket.techtarget.com/sDefinition/0,,sid183_gci213990,00.html
    http://www.dotnetspider.com/resources/193-What-GUID-How-generate-GUID.aspx


    My MS-CRM Blog
    Wednesday, February 24, 2010 7:10 AM
  • the risk might be low 
    but there is there a possiblility

    i am developing a custom application which is common for all the organizations in a crm enterprise

    so i am planning to use these guid's as the primary key


    Wednesday, February 24, 2010 7:18 AM
  • I have worked with guid in most of my applications. and trust me i never had faced this problem of uniquess. Plus since this is manged by SQL Server (uniqueidentifier) so i am almost 100% sure there will be no problem.
    Most of the components today live on GUID, so i think it should not be an issue. otherwise the whole idea of "Global Unique Identifier" is gone. :)

    By the way MS CRM is also using these GUID's as Primary Key. so for the sake or argument if hte problem Do comes (there is almost zero  chance of that) it will come in MS CRM as well :)

    My MS-CRM Blog
    Wednesday, February 24, 2010 7:24 AM
  • i agree that in crm it is unique in an organization

    but in multiple organization environment

    for example in org1 the account guid is abcdef1234

    is there any possibility of creating the same guid(abcdef1234) in org2

    as in crm org1 and org 2 are in maintained in different databases

    i feel that there might not be uniqueness in different databases

    Wednesday, February 24, 2010 7:30 AM
  • No i think, there is no chance, as i said its unique Globally and it indpendednt of database, system or for that matter MS CRM.
    to support my claims, check these for sql server uniqueidentifier.
    http://msdn.microsoft.com/en-us/library/ms190215.aspx
    http://en.wikipedia.org/wiki/Universally_Unique_Identifier
    http://www.mssqltips.com/tip.asp?tip=1600
    Muhammad Ali Khan My MS CRM BLog
    Wednesday, February 24, 2010 7:36 AM
  • so you say that no two guid's are same all over the world in all applications
    Wednesday, February 24, 2010 7:41 AM
  • Yes i do :).

    Read this

    The primary purpose of the GUID is to have a totally unique number. Ideally, a GUID will never be generated twice by any computer or group of computers on the face of the planet. The total number of unique keys (2<sup>128</sup> or 3.4×10<sup>38</sup>) is so large that the probability of the same number being generated twice is extremely small, and certain techniques have been developed to help ensure that numbers are not duplicated. (See Algorithm)

    http://en.wikipedia.org/wiki/Globally_Unique_Identifier

    It claims to be on the planet :). So As i said, its seems impossible :)
    Muhammad Ali Khan
    My MS CRM Blog
    • Proposed as answer by Muhammad Ali Khan Wednesday, February 24, 2010 7:46 AM
    • Marked as answer by VarunKumar17 Wednesday, February 24, 2010 7:49 AM
    Wednesday, February 24, 2010 7:45 AM
  • ok thanks for the info

    i am moving forward to keep this guid as ID in my database to identify a partigular record

    Thanks once again
    Wednesday, February 24, 2010 7:49 AM