I have a program that uses the SQLDMO BulkCopy object to create a text file,
then copy it into a database table on a server across the network. The
destination server uses SQL Server 7 and the source uses SQL Server 2K. This
program stop working with an error copy some table. The error is [Microsoft]
[ODBC SQL Server Driver] [SQL Server] Line 1: incorrect syntak near 'small'.

The data table does not have any data with 'small' in it, so I am assuming
it is a field type. This error does not occur on every table, just some.

Any ideas on the cause or better the solution?

Thanks in advance

WayneM