Doug Murphy
dw-murphy at cox.net
Thu Jun 5 11:21:45 CDT 2014
Are you appending the Primary Key or letting SQL server fill? In Access you can append a PK value into a table with a query. I am not sure that is the case with SQL Server. -----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