"Scrambled" results from remote stored procedure

[stevemiles]

I'm running into an issue where a stored procedure reverses the order of my print statements in its output - but only when it is run remotely. I've included a simplified example below.

Both servers are MSSQL 7.0.

Any help or thoughts are appreciated

CREATE PROC spTest AS
PRINT "a"
PRINT "b"
GO

-- executed locally
exec spTest
/*
Output is:
a
b
*/

-- executed remotely
exec Server.DB.User.spTest
/*
Output is:
b
a
*/

 

[Patrick2002]

I tried to reproduce this behaviour between two SQL 2000 machines, but that works just fine. So I thought it's a sql 7 thing and tried that, but it's fine too.
Do you have the latest Service pack for SQL and MDAC installed on both machines ?

Good luck