Just for 100% clarity. There is aconstant connection to the sql server which is open most of the times and all users using the site uses that particular connection, so...

"Second, the question that has not been asked here is that when you recieve the 5 column sheet is it the same 5 columns everytime? " --YES always the same

"Third, is...

I have never used SS7 myself, but am wondering if it has the ability such as ss2000 to export and import data? If it does I suggest you use ss2000...

How could I eliminate the cause of the pagefile being overloaded. My perf counters does not show a big number of page faults, only the occasional one.

Ok, that is agreed and that is what I thought, but why is SQL using so much pagefile memory. The site have an overnight batch process that runs each night...

Nope.

Customer 1 has modelname of 'customer_model_v1' and in the model column(blob field) it has a file saved.

Custome2 had modelname of 'customer_model_v1' and in the model column(blob field) it has a...

Thank you all for the help. The company is very sensitive to making changes so what I am doing now is to wite a quick c# app that will gnerate...

Well it is not really a many to many relationship, it is more 1 Customer to Many models. Under Models each customer can have multiple models, but the same customer...

Thank you for your replies,

Patric, that is correct, only 1 customer is not allowed to have the same two modelnames, but multiple customers can have the same modelname.

I am still...

Thank you for all the replies, I think the evidince is compelling to use DTS rather than Linkes servers.

Cheers

Rykie

Yes both sql 2k.

Try sharing a folder in the web as a Network folder and use a UNC path to do it.

Thank you, that worked!

Thank you, yes that is what I ended up using.

Yes, put all the code in a stored procedure and just execute the SP and supply it with the variables.

EG.

create procedure sp_emp

as

DECLARE @emp_group_name varchar(100)

SELECT @emp_group_name=b.emp_group_name

FROM mmmm_emp a INNER...