So what you are actually getting is conflicting messages between the visible output and the actual value within the variable.

Firstly, you are saying the string size is about 61K. This...

If by "at the output" you mean when you try to display it in the SSMS query window, you may find that there is a limit to the number of...

My pleasure Barabara. I have to know these things sometimes for myh own work, so the time isn't wasted and I've had plenty of help from others, so it's nice to...

Hey Barbara, this time I think I can help you out. Did a little research and it looks to me as though you are on the right track, just changing...

Have you tried running the script in SQL 2005 to see if it is an environmental issue?

Have you tried generating the script again to see if it was a one...

At a guess I would suggest that restarting the job may have been insufficient to pick up the new settings. Perhaps you need to bounce the SQL Server Agent - just...

I would suggest that you re-check all of your permissions settings to ensure that you have correct access to the IIS server and that the user you are accessing with...

Great for SQL Central and the boys who started it.

Great for me as I made the cutoff for SQL Prompt. Looking forward to he email (which hopefully doesn't end up in...

Thanks for the article Janet. I particularly like the "multi-threaded" approach with the temporary jobs. Even though I don't do any DTS work at the moment, I like the approach...

From afar and in an environment where we don't need to rely on vendor tools (at least not yet), I use this site to ask questions about HOW to do...

Good to see you guys sort it out. Proves there is still hope in this world for people who can communicate honestly.

As for that group beer, can you send one...

255 is usually a significant number in this industry of ours. I wonder where that fits into the issue you just mentioned.

Congratulations guys.

From a community user perspective you were definitely successful.

Hope the bank balances are appropriately flooded and that you each take time to spend with your families and give...

The following link gives you a simplified version of how to do this

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=319791

And there were some other suggestions (including the above link) here

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=319189#bm319729

I just tried the first osql cmd you wrote in SQL 2005 and replaced osql with sqlcmd

osql command runs in 7 seconds

sqlcmd runs in 2 minutes 26

SQL 2005 docs...