I keep getting this error.
String or binary data would be truncated
I've done numerous checks to make sure the fields are large enough for the data, and they are. Somethings just not working. I don't care if the data is truncated. I read a post aobut using the SET ANSI_WARNINGS OFF but I can't seem to get that to work. I am using ASP.NET with an SqlDataAdapter to add 55,000 rows to a newly created table from a "|" delimited text file.
I use EMS SQL manager, and I tried executing a script on the database:
SET ANSI_WARNINGS OFF
and I still get the "...would be truncated error"
How do I set it so that it truncates it? I have 75 columns so there has to be an easier way then going through and truncating each objRow("fieldName") = myData(0) within the code.