SQL Server 2000 Hitting 8000 Byte Limit Exporting BLOB
You should be using the Bulk Copy Program (BCP), a command-line utility that ships
with SQL Server 2000, for importing and exporting large amounts of data in
SQL Server 2000 databases.

For more information see the Database Journal article
Utilize BCP with SQL Server 2000.