Hi Will, Set the identity seed to 1000 in enterprise manager.
-- Pete Freitag http://foundeo.com/ - ColdFusion Consulting & Products http://petefreitag.com/ - My Blog http://spendfish.com/ - Fish for Deals On 1/3/07, Will Tomlinson <[EMAIL PROTECTED]> wrote: > I've decided to change an orderID PK from varchar to int data type. I'll set > it to have a yes identity so it'll increment, but how how do you set it to > start at say, 1000. I don't want people's orders starting at 1. lol! > > Thanks, > Will ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265528 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
