Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par Mushtaque Inamdar , 1. System Analyst. / 2. Application Development. , MicroServe
Date de publication: 2017/03/08
Deepak Hariharan
par 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