A. The 255 limitation is a Query Analyzer option - you can change it - or use OSQL.EXE which won't show this limitation.

Go to Query/Current Connection Options/Advanced and change max chars per column to whatever maximum you desire.