There is an issue with modifying a varchar datatype column when I have a ntext and/or text datatype column in the same table. In the Explorer Database Objects window's data tab, when I modify the varchar column while the ntext/text column says (Excluded) in the data grid, once the modification is committed, the ntext/text columns data will be changed to NULL.
WORKAROUND:
Before making the change, click on a cell in the text and/or ntext column that says "(Excluded)" to rerun the query to show the actual values for the text and/or ntext column(s). After the actual values are showing, make the change and commit it. With the actual values are showing when you make the change, they do not become NULL.
STATUS:
Waiting for fix to be released in a future version of Toad for SQL Server.
