have you tried

delete from openquery(linkedserver, statement)

??

The problem is that you are calling the proc which exists in the database, therefore you have a connection to the database and so cannot restore it.

Try creating an Admin...

Can you post the code of the proc and how you call it?

Import the data into a worktable then run a join to check for the new data and then insert what's new.

I'd recommend "Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook" by Ken England (ISBN:1-55558-241-9)...

Available from good book stores everywhere (yeah right, order it online or you'll never find it)

Should I find it I'll let you know

Changing the data type for the subjectid to an int you could use the following. It's not the most elegant, I am sure that there are a lot better ways...

That's what initially made me come up with the question. I was looking into performance regarding hyperthreading as there are several people who have mentioned issues with SQL performance with...

Is the SubjectID going to be a character field or is it going to be numeric?

Are you using the database when you attempt the restore? Confirm that you are not in the db when trying, also run and sp_who to check that there are no...

In the DTS Designer add a text file connection, locate the file, then hit the properties button, select fixed field, hit next and check that the markers are in the...

Looks like the user does not have folder permissions to write a file to the server. Check his NT permissions.

Why use a dts if you don't need to? Just run an insert as a part of the proc.

I feel your pain there.....

How about creating a proc and using a cursor to pass in the tables that need to be updated and then updating the table based upon...

It should make a big difference, log truncation does not always happen even after checkpoints have been issued. I know it's what you would expect but in the past it's...