Is it prossible to combine field value when doing bulk insert?? And
Not as far as i know. Maybe one solution would be to buult insert into
another table then manipulate the data from there via either updates or
I hope this was of use.
Steve Robinson SQL Server MVP.
I am running a job out of MS SQL Enterprise Manager where the first step
turns off transaction logging, the 2nd step is a large bulk insert step,
and the 3rd step is another large bulk insert step. I receive the
following error when executing the 3rd step. Is this error occurring
because the database is still comitting data from the previous large bulk
insert at the same time as it is performing the next bulk insert? If so,
is there a workaround? Thank you for any help you can provide.
Error message from Step 3 (2nd bulk insert):
Backup, CHECKALLOC, bulk copy, SELECT INTO, and file manipulation
(such as CREATE FILE) operations on a database must be serialized.
Reissue the statement after the current backup, CHECKALLOC, or
file manipulation operation is completed. [SQLSTATE 42000] (Error 3023)
The statement has been terminated. [SQLSTATE 01000] (Error 3621).
The step failed.
Posted via CNET Help.com