[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 239
  • Last Modified:

Bulk Insert Failed

I am recieving an error message through and application that :

Bulk load failed
Can't connect to server GANT12, database Millennium, user Millennium, COM error 0x80040000

Merge failed
0
caryma
Asked:
caryma
1 Solution
 
David ToddSenior DBACommented:
Hi,

Silly question, but is the bulkcopy option set on this database?

ie
sp_dboption 'pubs', 'select into/bulkcopy'

Regards
  David
0

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now