All that work, and the page title reads "Tested in 2018 by Vermont Department of Public Servivce". Corey Chase has been let down.
188 posts • joined 16 Dec 2009
We regularly had conference calls with one colleague where the sound from his end would fluctuate from 100% to 0% throughout the call. We eventually discovered he kept his laptop right on the edge of his desk and when he leaned forward to emphasise a point, his stomach covered up the microphone on the computer. He uses a headset now.
SQL Sever 2017 error
Msg 8152, Level 16, State 14, Line 8
String or binary data would be truncated.
SQL Server 2019 (trace flag 460 enabled)
Msg 2628, Level 16, State 1, Line 8
String or binary data would be truncated in table 'Sandbox.dbo.Customer', column 'CustomerName'. Truncated value: 'Is this th'.
The IT department manager (an accountant) once phoned the help desk to find out why his wireless mouse wasn't working while he was working from home. We eventually asked whether the receiver was inserted properly, to be told it was definitely plugged in - to the docking station on his desk. In the office.
When someone complains that the data in a CSV file has been corrupted the only question you need to ask is "Have you opened it in Excel?" as Excel knows best when it comes to dates, telephone numbers, etc. My standard format specification when receiving data from third parties is "Anything other than Excel".
Biting the hand that feeds IT © 1998–2019