Superlative Solutions' HelpDesk Language
 
Home Knowledge Base Web Hosting Enble BULK INSERT for a SQL Server databse
Information
Article ID14
Created On3/15/2008
Modified3/15/2008
Enble BULK INSERT for a SQL Server databse

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