One of the more annoying things that I have dealt with in SQL Server is inserting a large amount of data, only to have this message appear.
Msg 8152, Level 16, State 30, Line 14
String or binary data would be truncated.
The statement has been terminated.
When you are importing a large number of rows, this is an annoying message. For me, anything more than 100 rows is large because I can’t easily dig through a file and find out which rows are problematic. When I have 1000 or more rows, this makes me want to