BCP.exe and @@TEXTSIZE
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Have any of you figured out a way to export and import text blobs with content greater than 64512 bytes? I have hunted and hunted through Google and the MSDN library, but nothing indicates a way to tell BCP to export more than the first 64512 bytes of the text on a row. It may also help if there were a way I could set the default TEXTSIZE for all new connections, but I haven't found a way to do that either. Any ideas? (If you have some nice little utility that can generate a series of INSERT statements to copy the content of the table, I could get that to work too. In fact, I'm starting to look for one, but hoping that I don't have to go that route.) John