Avatar of Rog D
Rog D
Flag for United States of America

asked on 

Appending SQL Tables from MS Access SET IDENTITY_INSERT takes a long time why?

MS Access append query to SQL Server table.  SQL Table is blank but does have identity column.

When I run the SET IDENTITY_INSERT [Table] ON;

I try to run the Append Query in MS Access, but get a Key Violation.  

If I wait X minutes then run the same Append Query again, it adds the records.

I am wanting to speed this process up as I have many tables to work on.

What is the best way to do this?

SQL Server 2012 R2

Microsoft AccessMicrosoft SQL ServerSQL

Avatar of undefined
Last Comment

8/22/2022 - Mon