Ay yi yi, a table is a list of rows, at least to me.

Need to multithread your app.

Agree with Chris. Do it as a function in the app/.

Use a network sniffer that can read TDS

If you query the table using the BETWEEN without the other tables, is the index used?

Havnen't seen the "ignore" part. Are you building the transform by hand or using the wizard?

Is this a regular conversion or a one time thing?

There is no way directly to do this. You need some software that can read the PDF as you used. If things didn't work out, you could search for software,...

bigger hardware, separate servers, etc. There are normal items that improve the speed at which things work.

These are the security settings for how oyu connect to the server. Windows is probably what you are used to.

Haven't seen that.

The location of master is a parameter in the service startup. At the DR site, setup the startup parameter with a different master. Then when it comes up, you'll need...

I don't recall that message exactly, but did you log in as the account that is running SQL Server and setup a profile that way?

There is likely a reason in the error log that gives a clue as Mom mentioned.

I've had some boxes run this long in the 2002 time period where there were few or no SQL Server patches and few W2K patches that we let build up...