Description of Issue
By default, when a database is created, BULK COPY options are disabled.
(NOTE: This article only applies to Superlative Solutions clients who are utilizing our SQL Server options)
Resolution
In order to change this behavior, in SQL Server 2000, you should execute the following command using the Query Analyzer:
sp_dboption @optname='select into/bulkcopy', @optvalue='true'
To disable BULK INSERT options, simply change the @optvalue to FALSE