As I wrote previously I installed new msdtc resource through configure application and it helped me. But when I got your recommendations about reinstalling I followed them in order to...

Thanks again! All went just fine

It looks like I've solved the problem but not sure that clean. I went through configure application (not create new resource) and it created msdtc folder in disk J. Now can I...

It looks like I have a problem with MSDTC. You said that there is a difference on setting up resources between win2000 and win2003, so I don't want to risk and...

It means you don't have enough rights to change this. Also I guess you are not one of the server local administrator group member and you don't have sa rights....

Ok thanks again. It looks like my work hours come to end. Tomorrow I'll try to reconfigure MS DTC. Friendly speaking I don't understand why MSDTC needs separate IP address,...

Yes I understood that therefore I think to make separate MS DTC group. The previously typed steps looks ok? And maybe you could tell me from your practice what size of...

Thanks c70070540. Yes it's clear for me. It was interesting whether 2 IP addresses for SQL server instances must reside in the...

Thank you both for your help and particularly to c70070540  Yes I'd read all these KB...

The main thing is that your user will have both groups privilleges and permissions. If one group allows to modify or control particular objects on the particular DBs and the second group...

Thank you for your correction. Query I meant command. So what I'd done if I were you is to put db2.pipe_stuff into " " :

bcp "DB1..PIPE_STUFF" out \\OtherServer\Data\pipestuff.txt -T...

Hi,

could you show us your query?

A couple month ago I guess I had a problem like this. There was a library DB with different language data like english, lithuanian and russian. So I wrote a script which...

It's not essential to have linked server to test this syntax

I wrote simple script to test your syntax and found out. Try to replace such parts as

EXEC ('SELECT name into...

I'd studied log shipping far and wide and agree with Kathi. As there was said: "it's all or nothing"