What cache file?

Andy

You're outside my experience at that point. I find linked servers incredibly useful and I would guess (not tested) that there is a little less overhead since your setup is...

Not without converting to a string that I can think of. Normally that's what you would do, store as a number, display as a string so you can stick leading...

I'd say for two reasons. One is that you're making one trip across the wire, not a couple hundred as you loop through the outer recordset to get the "child"...

I'd say step out of DTS for a minute, attack this with plain VB or VBScript. Try to write some code or pseudo code that describes how you would do...

Thanks for the follow up Penny - definitely a chance someone else will run into the same thing.

Andy

Or you might need to set it on your ADO/RDO/DAO connection.

Andy

Or you might need to set it on your ADO/RDO/DAO connection.

Andy

Here is some code I did quite a while back, then Leon and I revised for a recent project. Has been lightly tested. You'll need to set a reference to...

Its pretty straight forward coding. You need two triggers, one for updates and one for deletes. Delete would look something like this:

Create trigger d_tablename on tablename for delete as

--cascade delete

Delete...

Take a look at this article:

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q241643

Andy

Have you looked at this article:

http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q260895

Are you running the most recent MDAC on your COM+ box and the latest SP on our SQL box? Are you logging everything so you...

Gotcha. I'd really suggest looking for a good exchange web site, maybe get some other ideas. Your current solution doesn't seem bad - does it take long or just not...

Try shift-delete so it doesnt go to the recycle bin maybe?

Andy

Would you mind posting the answer?

Andy