wayne-862477 (12/1/2010)

---

The problem is that "IsNumeric" does not validate for something that will go correctly into an int or decimal field -- which is a problem throughout Microsoft's code. ...

This is in the 32-bit version of SQL Server as well. In my experience, it's usually good practice to store the generated dynamic SQL in a log table for...

A solution I've found for this issue of SQL Server truncating the VARCHAR(MAX) value is to right click the table I want in the Object Explorer and "Open Table". ...