I get the following error when I try something like:
insert into dbX.dbo.A select * from dbX.dbo.B
String or binary data would be truncated.
The statement has been terminated.
The schema of both the tables are the same and look like:
Does anyone know why this error should come when the schemas are the same (so no fear of chop)? how can i work around this if not?