Will Dearman's Lifestream Daily Digest for June 27th, 2009 includes 3 items:

	Defeated by SQL server today! I'm having issues getting large amounts of text (XML) into an nText field. It is totally beyond me right now [#] — 7:03pm via Twitter
	Figured it out... needed single quotes and no apostrophes or line breaks. Success FTW! We are almost there. Will totally "CRUSH IT!" next wk [#] — 8:04pm via Twitter
	Interesting post by @thinkc about health insurance and its affect on entrepreneurship http://bit.ly/1bxeu [#] — 8:05am via Twitter

Will Dearman's Lifestream Daily Digest for May 13th, 2009 includes 3 items:

	Shared 8 links. — 5:41pm via Google Reader Deutsche Bank Is "Seeking To Destroy Competition" For Cosmopolitan And MGM CityCenter Megacities Threaten to Choke India Verizon Dishes off Rural Assets to Frontier in $8.6 Billion Deal Ecommerce Know-How: Writing Product Descriptions that Sell New Tricks: Use expanded Google search as a reporting tool Consumers Still Aren't Buying Gadgets April Web Stats: Fewer Domains, More Page Time, Longer Video Viewing Thriving Norway Offers a Lesson in Frugality
	Shared Thriving Norway Offers a Lesson in Frugality — 6:05pm via Google Reader
	<tech speak> Rejoycing that I finally got DTS to work on our SQL 2008 Express install. No more BCP XML export garbage </tech speak> [#] — 6:17pm via Twitter

This took an unfortunate amount of time to figure out, so here goes: 1) Using the command prompt (NOT THE QUERY WINDOW), type: bcp DatabaseName.TableName out nul -c -fTemplate.dat -Slocalhost\SQLEXPRESS -T 2) The result should be a file named Template.dat that will contain your column headers from that table. 3) Now using the command prompt type: bcp DatabaseName.TableName out D:\TableData.dat -c -fTemplate.dat -Slocalhost\SQLEXPRESS -T 4) The result should be a file named D:\TableData.dat that contains all of that table's data. Additional Notes: It turns out I was running an old version of BCP, which is why I could only use tab-delimited file formats and not XML (the -x parameter). More info here. To use XML, which is preferable, simply add the -x parameter to step 1. Currently upgrading to SQL 2008 Express to resolve the issue.