-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 > In any case, SQLServer doesn't exactly have > an AutoNumber field, so a different mechanism > will have to be identified for automatically > creating PrimaryKeys - if that's what you > really want to do. Umm... What about identity? Works nicely, and generates autonumbers. Just set the seed & increment values to 1 (the default) and the type to int. It works just like Access. The SQL Upsize Wizard doesn't automatically set them up for you, but you can add them in manually after the upsize. Best regards, Zac Bedell -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 6.5.3 for non-commercial use <http://www.pgp.com> Comment: Please use PGP!!! iQA/AwUBOYrwoAraVoMWBwRBEQJh7wCfXl9oDcsMiSRyyKI5EtYvC2i+jQUAn1dj hcYf/T7kyuKmic9++b/1Edho =M3TR -----END PGP SIGNATURE----- ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
