Skip to main content

Notifications

Customer experience | Sales, Customer Insights,...
Answered

How many sequences are available for auto-generating?

(0) ShareShare
ReportReport
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,752 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,752 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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans