When you do the transfer enssure you select the bottom option (in sql server 2k) that specifies that tables and objects are moved across.. This will ensure that identity fields etc are copied across
HTH -----Original Message----- From: Jason Larson [mailto:[EMAIL PROTECTED]] Sent: 13 February 2002 22:13 To: CF-Talk Subject: OT: Keep the Identity when moving MS SQL Database I was wondering if anybody out there had some info concerning transferring data from one MS SQL Server to another. I want to keep all aspects of the database the same. When I have done this in the past and exported the data to another server it did not retain any of the identity fields. Any Suggestions? Thanks Jason Larson [EMAIL PROTECTED] ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation · $99/Month · Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists