It turns out that OPENROWSET will not work for me:

SELECT *

FROM OPENROWSET('SQLOLEDB','Server=sql_server_network_name\instance_name;Trusted_Connection=Yes;Database=Master',

...

Since two of us asked the same question at the same time, this is the URL to the other thread:

http://www.sqlservercentral.com/Forums/Topic1258885-391-1.aspx

shew (2/28/2012)

Hmmmm... I...

Sean Lange (2/28/2012)

Because the homework question said to not use them??? Such a strange request and twice...

We have audit restrictions. It's just waaaaaaaay too much hassle to get permission, document what we are...

That is wild. I googled a while prior to posting, but I didn't find anything useful....

Hmmmm... I already...

Hmmm... It looks as if this truncation is a limitation of the print command. http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=95740

The data appears to be intact, and I can access it in 8000 byte chunks.

print '###...

Thanks for the feedback. SQLCMD.EXE and SSMS are truncating the data at the same place (~7700 bytes) in the output. Both tools report the data as being 9741 bytes long.

The data appears to be 9741 bytes long in the database, according to "select len(column_name)..."

I am running with SQLCMD.EXE under PowerShell because of the column truncation that normally happens in SQL Server Management Studio.

However, SSMS and SQLCMD.EXE appear to be truncating the data at...

GSquared,

One more question...

I started down the path of using XML because I read a Google hit that said XML would retrieve the entire column (presumably even for a varchar(max) column)....

Thanks, that works better. 🙂

GSquared,

XML is not my strong suit...

When I tidy up the output from your sample query, I am seeing multiple table tags, which can cause the data to misalign. Is there...

Thanks for the tip. That gets rid of some replace statements.