I would like some advice on the SET ANSI_WARNINGS OFF.
I had a pretty complex query that was returning the "String or binary data would be truncated" error message so I dropped in SET ANSI_WARNINGS OFF. What (if any) are my issues with using this statement? Is there a more simple way of identifying the "String or binary data would be truncated" error message? Is it possible to see the truncated records to pin point what was the problem? I know there are alot of SQL gurus on this board ... so what I'm hoping for is a shortcut to get me past this message and advice on the pro's and con's to using the SET ANSI_WARNINGS OFF.