Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Why (Sometime) SQL Server query insert twice instead of once? specially when traffic jam and slow response of Network.

user-image
Question added by Mushtaque Inamdar , 1. System Analyst. / 2. Application Development. , MicroServe
Date Posted: 2017/03/08
Deepak Hariharan
by Deepak Hariharan , Senior Software Developer , DB Schenker India Private Ltd

One of the possibilities. The table is not having a primary key or unique key. The constraints may be disabled before firing the insert statement. If the table is having primary foreign key relation ship it is not at all possible.Or might be be you are seeing a merge replication or snap shot replication of the server.

More Questions Like This