I think you misunderstood, the formatfile matches the table definition. The question is why bulk insert creates an error file and then deletes it from disk once finished running?

For...

bulk insert from "e:\datafile.bcp"

WITH (FORMATFILE = 'e:\formatfile.xml', maxerrors=0, errorfile='E:\import_error.txt')

It's when we create a proc.

Thanks, the sql was a lot of help!

think about this id as a department id and not the identity for the user, so we can assume that 1 is a value from a lookup table, which could...

"The one thing I did find really bad about the quorum when I first learned about it is that when you failover to your mirror and it becomes your primary,...

SQL server can go up to 6.5GB of RAM, but was using around 6 at the time.  The server has 8GB total

That's what we've been planning on doing.  Perhaps it will happen soon.  Another question is: why would it stop suddenly?  In other words the problem goes away after an hour. ...

I tried to reinitialize, but the message still reported "Snapshot not yet available".  Only drop/recreate helped.

Only through an ODBC driver.  There is one from some company.  I can't remember the name.... I haven't done anything with Progress in a few years.  Just search for Progress...

Also make sure that you use new joins as in LEFT and RIGHT and not *=, =*.  Old style joins don't work with db90.  So if you have a lot...

This happened on the end user's workstation, so I have no idea of what they typed in.  However I don't think it was the case.  They are not that familiar...

I guess the point being is that the select query finished running, but the blocking still occured.  I know that nolock will avoid the problem, but some other users who...

Thanks, and how do you split the source table based on the delimiter that's in the first column and move it to destination table?  Basically how do you parse for...

When creating an index it's an offline operation, SQL never allowed access to tables while creating or rebuilding indexes by default.  You can specify with online option, but it will...