Does anyone know if the stored rocess sp_MSforeachdb will work? I have not found any examples of that so far.

I am stuck on this again...

now it looks like new databases will be added to the remote server almost every weekend. it could even be more then 1 thats added....

I think you have. I just was trying to see if there is an easier way then to go through all the db. but this will definitely work.

Thank you...

thank you sara, it worked like a charm with a little modification of the fields that I wanted. Thanx again

That worked like a charm thank you very much urvashi.

I just installed .NET on the server and I still get this error.

When I go into the design of the package on the server and look at the Transfer...

Thank you for all your help and ideas.

"Tarique - I think there was a disconnect here...I was suggesting you keep a separate "deleted table" that would have objectID, tableID, UserID,...

sushila,

"1) Your objectID is not useful at all...you should use docID, AddressID etc. since this is the only ID that uniquely identifies your rows."

What I was thinking of doing is...

Each table has an Identity ID which I guess i didnt show. My mistake on that. I tried to keep the post to a minimum.

It is IDENTITY and I am using

SELECT @@IDENTITY AS NewID

right after I do the insert to get the ID. this way this ID is my ObjectID.

"When a specific row...

the requirements are:

there are processes, documents, contacts, addresses, company info, stores info, employee info, insurance for each, 401k info for each etc. processes can have multiple documents attacthed to it....

what i am going to do is:

tblDocument

ID   docID  docName   docLocation   docVer

99   1        temp.txt    c:\abc          1.0

when client changes c:\abc to c:\xyz then

tblDocument

ID   docID  docName   docLocation   docVer

99   1        temp.txt    c:\abc          1.0

100  1       ...

sushila,

I was thinking about/discussing the situation last night. The solution I, with help from co-workers, came up with is we will keep the tables as is and have a status...

the example of Document that I gave is just one part. similer will apply to address records, contact names. phone/fax etc numbers, and other company related information. If it was...

Thank you very much Noel. it worked perfectly!