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
