thanks for that.

I orginally tried using a execute sql task to perform the insert/update, but the only databases that I can select from the linked server is the master database, but the database...

For some reason I cant get the execute sql task to work, so I'm going back to the data driven query.  Im using this activeX vbscript to either update or...

Thanks again for your reply, It was a typo in the forum post.  I've made a connection between the 2 databases using connection tools in the DTS package, but I...

Thanks again for you help.  Im testing the sql for the execute SQL task, and im getting this error:

Server: Msg 7314, Level 16, State 1, Line 2

OLE...

Thank you very much!!!!!!, btw, if I wanted to go with the active script, how would this code need to be modified to do the same thing as the execute...

thanks for that.  I've abandoned the activeX and have decided to use an execute SQL task using this tsql:

INSERT INTO dbo.Target

SELECT *

FROM dbo.Source AS s

WHERE NOT EXISTS

(

SELECT 1

FROM dbo.Target AS...

thanks for that.

ITS OK, I FOUND THE ANSWER.

how do  I do that

is it possible to use the .mdf in any way for a restore?

great.

 thanks

I have some backups in the filegroups or files section (mdf's)  dated from yesterday could I use them to restore?

Thanks, worked perfectly. Turned out the value was hard coded into a connection string that was stored in a table.

Many thanks.

Thanks for your reply.  The value could be in any column. but its more likely to be in the System_DB column. Since that is column that contains database ID's