I figured it out after reading the details of my job step. It said I didn't have permission for Non-Admins to run CmdExec job steps. I added a...

Worked great!!! thanks... You expert DBA's on this site are a life saver.

Wow, thanks. It appears that Query Analyzer only shows 255 characters, when I did the len(comments) as you suggested it returned 420, the exact length of the string I...

I ran sp_dbcmptlevel and it returned 80, which I think means SQL2000 compatibility, right?

Any other suggestions? This has stopped me cold during development. What am I doing wrong?

...

Thanks for the quick reply. I'm using the Query Analyzer tool and I'm running the following SQL statement:

INSERT TestTable(Comment) VALUES('xxxXXxx')

Note: The string xxxXXxx is a string of more...

Thanks for trying, but the data is from two totally different tables. One table shows header data and the other is the detail data for each header.

I found an...

Thank you nigelrivet. It works fantastic!! Many, many thanks and have a wonderful holiday...