Forum Discussion
Reacher01
Aug 06, 2024Copper Contributor
ERROR 4819
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 in...
rodgerkong
Aug 07, 2024Iron Contributor
Check DB configurations, constraint on target table.
Reacher01
Aug 12, 2024Copper Contributor
- rodgerkongAug 12, 2024Iron Contributor
execute sql below in both server, check results
SELECT name, collation_name FROM sys.databases WHERE name = N'Your DB Name'; --replace the string to your db name