Rocky Smolin
rockysmolin at bchacc.com
Thu Jun 5 11:00:09 CDT 2014
Are you trying to append the key from the source table to the target table? Rocky -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Jeff B Sent: Thursday, June 05, 2014 8:56 AM To: Dba-SQL Subject: [dba-SQLServer] Appending Data with AutoNumber in SQL Server I am going to post this in the Access group as well, as a separate email. I am trying to use MS Access queries to append data from a table in one SQL database into a table in a second SQL database. The first contains live data that needs to be moved to a test database. I have deleted all of the data from the tables in the second database, and have reset the auto number (or identity in SQL) back to 0. However, when I try and use an Access append query, it fails and tells me there are key violations. I thought that be deleting all data and reseeding the identity, I would avoid these problems. Anyone know what I need to do in order to make this work? Jeff Barrows MCP, MCAD, MCSD Racine, WI jeff.developer at gmail.com _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com