Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Answered

How many sequences are available for auto-generating?

Posted on by Microsoft Employee

Assumedly auto-generated numbers that have sequential numbering are employing a database sequence.  Generally the database engine limits the number of those available.  How many auto-generated fields with sequences can an org have?

TIA

  • RE: How many sequences are available for auto-generating?

    .

  • Verified answer
    Fubar Profile Picture
    Fubar 2,750 on at
    RE: How many sequences are available for auto-generating?

    So basically you need 1 auto number field per Entity - which is probably not going to be an issue.

    It is managed by SQL Server as per the brief mention in docs.microsoft.com/.../create-auto-number-attributes

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How many sequences are available for auto-generating?

    Good question.  Following the pattern used by msdyn_salesordernumber, I want to use them as identifiers for the Dual Write integration keys on custom entities.  Shouldn't be more than a couple of handfuls per org.

  • Fubar Profile Picture
    Fubar 2,750 on at
    RE: How many sequences are available for auto-generating?

    I haven't seen anything discussing limits on number of the autonumber fields you can have in your organisation, but I would start with what is it that you need to do that requires a lot of them?

    Note, there is a limit on the number of custom entities that you can create in CRM and this would impart a practical limit

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How many sequences are available for auto-generating?

    Apparently there are plenty on the server but, in the cloud there is the question of sharing --

    https://jonshaulis.com/index.php/2018/06/27/how-many-sequences-can-i-have-in-sql-server/

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,552 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,552 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans