Important Notice from AspDotNetStorefront
It is with dismay that we report that we have been forced, through the action of hackers, to shut off write-access to this forum. We are keen to leave the wealth of material available to you for research. We have opened a new forum from which our community of users can seek help, support and advice from us and from each other. To post a new question to our community, please visit: http://forums.vortx.com
Results 1 to 2 of 2

Thread: Update starting order number

  1. 04-07-2011, 05:04 PM #1
    HomeIndoor is offline Member
    Join Date
    Nov 2008
    Posts
    64

    Question Update starting order number

    We recently has an issue with our database where I now need to change the next order number to be used. So for example, all of our orders started from 100000, so I now want to change then to 200000, so that the same order number does not get used.

    Please advise how to make this change.
  2. 04-08-2011, 01:06 AM #2
    esedirect is offline Senior Member
    Join Date
    Feb 2010
    Location
    Norfolk, UK
    Posts
    343

    Default

    DBCC CHECKIDENT (ordernumbers, RESEED, 199999)
    http://www.esedirect.co.uk
    --------------------------------------------------------------------------
    Using MS 9.2.0.0 with the following customisations:

    Lightbox/Fancybox enlarged images;
    Auto-suggest searchbox;
    Extra product information shown only to our IP Address (such as supplier info, costs, etc.);
    Failed transactions emailed via trigger;
    Custom app to show basket contents when customer online;
    Orders pushed through to accounting systems.

    All the above without source!