SQL Server: 2019

ERROR (4819) -” Cannot bulk load. The bulk data stream was incorrectly specified as sorted or the data violates a uniqueness constraint imposed by the target table. Sort order incorrect for the follow”

We tested the exact same stored procedures on SQL2019 System A and everything worked as expected.  But it gives errors when we test on the SQL SERVER 2019 System B.

  SQL Server A and SQL Server B are the same version, 2019 but something is causing these jobs to fail.

I’m not sure what to do next.  Any thoughts/suggestions would be greatly appreciated.

Thanks.

​SQL Server: 2019 ERROR (4819) -” Cannot bulk load. The bulk data stream was incorrectly specified as sorted or the data violates a uniqueness constraint imposed by the target table. Sort order incorrect for the follow” We tested the exact same stored procedures on SQL2019 System A and everything worked as expected.  But it gives errors when we test on the SQL SERVER 2019 System B.   SQL Server A and SQL Server B are the same version, 2019 but something is causing these jobs to fail.I’m not sure what to do next.  Any thoughts/suggestions would be greatly appreciated. Thanks.  Read More

​