That did it! Problem was that on the originating WinServer 2003 (Server 1), the Component Services / MSDTC / Transaction Configuration / Security Configuration / Transaction Manager Configuration was set...

Yes, we did. The article applies to Windows Server 2003 which is the originating server (Server 1). Server 1 is configed as per the article, and does work with another Windows Server...

Yes, it is.

Great! Thanks very much!

This would be multiple publications on 1 server 1 db pushing multiple subscriptions to another server 1 db. It is possible and does work. Just wondering about the performance advantage/disadvantage...

Bingo !!! The key I was missing was the ol' "RAISERROR 99999 'Failure'". Doesn't take much to stop a horse, does it? Also, thanks for the alternative -- the registry...

Let's say that a SQL Task in a DTS calls the stored procedure which 'RETURN's a value. What is the SQL syntax to get the DTS to interpret that value...

I created SPROC:

create procedure dbo.stp_test

as

if GetDate() = GetDate()

begin

RAISERROR ('DTSTaskExecResult_Success', 16, 1)

end

When I ran it via SQL Query Analyzer, I get results:

Server: Msg 50000, Level 16, State 1,...

Thanks for the responses. Before I tackle the NT method, is there a way for a SQL Task (version 7.0) to evaluate a return value from a stored procedure and...

Said I'd get back and here are our findings. Esentially, nothing to add to the previous posting, except that it's imperative that SQL Server Agent have valid id, password and...

Just a note to let you know we're still around and trying. Thanks to all for the great suggestions, we finally got it to work twice, and are still in...

Thanks to all so far for the input. My responses to Steve are in [CAPS].

MAchine1 - SQL Server 7 server, has dts pacakge. [CORRECT]

Machine2 - Remote Windows server machine containing...

Simon, SQL Agent is running under the domain account, SQL Server is not. The DTS is being fired by a CmdExec in the job (example: DTSRun /S GGGSVR199 /U sa...

Not sure by what you mean by logging in with SQL Server account. In addition to logging in with SQL Agent Id, we also logged in with sys admin id....

Here's another one that I came across the other day. Documentation says it's supposed to take care of the midnight issue. (Apologies to the author of this code for no...