From within your storefront’s “Run SQL” option under “Configuration” | “Advanced” (or from within SQL Mangler, I mean Manager, enter the following command:
dbcc checkident(OrderNumbers, reseed, XXXXXX)
Where XXXXXX is the new number you want to use as your seed.
This can come in very handy if you moving from one storefront to another to ensure a continuity of orders.
At Over The Top and Exhibit A Communications, I've programmed solutions for Google as well as at least one other company that was later acquired by Google.
I've been CTO of an Internet SaaS company and spent my time pretty evenly between guiding the future technical strategy of the company, architecting software solutions for my dev teams, designing and running a data center to service our clients world-wide as well as being a technical evangalist/sales engineer to our media clients large and small.
I've also been Chief Photographer of the Daily Sun/Post newspaper back when it was a 5-day a week daily newspaper.
I also spent a great many years as a beach lifeguardfor the City of San Clemente as well as Jr. Lifeguard instructor and then as it's program coordinator.
Private Pilot with Instrument rating and proud husband of soon to be 25 years (and counting).