If you have SQL Enterprise Manager MMC, (client tools with SQL Server), go in I modify the Auto Number fields to "Identity", make sure you set the start point above the highest current UID in each tables current Auto Number field.
Hth and makes sense. Mike Brunt - CTO Webapper Services LLC http://www.webapper.com Downey CA Office 562.243.6255 "Making the NET Work" -----Original Message----- From: Ewok [mailto:[EMAIL PROTECTED]] Sent: Sunday, July 28, 2002 1:48 PM To: CF-Talk Subject: Convertnig MS Access database to SQL server Hi me again :) I just converted an access database to SQL server for the first time. I had all the primary keys set to autonumber's (no duplicates) in access but when I converted to SQL server it simply made them Int's. I had to go through and set each table's primary key to identity. Is there something I'm missing that will do this for me when I convert so I don't have to manually set them every time or should I write some code to get the max id of the primary key and increment it before I insert the new row? ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
