Yes, something like that but please review the link posted above.  There are many other issues that must be addressed and this article does a great job of explaining everything.

Raiserror always returns its message directly to the client.  So in this case an error in procedure ONE has already sent the error message to the client and Procedure TWO...

Thanks to Remi and vhanda for pointing out the use of TOP 100 Percent as a fix.

As I recall the "bug" was the fact that it states "Order By" in...

...select_statement

Is the SELECT statement that defines the view. It can use more than one table and other views. To select from the objects referenced in...

Oh, I think your were clear.  It's just that no one has an answer for you.  I couldn't find anything in BOL that would help.

It all works fine if the procedure setting the isolation level is the first procedure called and no other procedure changes the isolation level. 

First, I don't think you want to be using IDENT_CURRENT in this case becuse it will give you the latest identity value inserted for the specified table by any user...

The problem here is that if the isolation level is already higher (and you don't know it) by setting the isolation level to your desired need you may inadvertently be...

Ok, thanks.

From BOL

/*...*/ (Comment) (T-SQL)

Indicates user-provided text. The text between the /* and */ commenting characters is not evaluated by the server.

Syntax

/* text_of_comment */

Arguments

text_of_comment

Is the character string(s)...

Why?  You don't know if the problem is RDO related and are you saying ADO is without its problems?

Remi,

Can a stored procedure return a table to a calling sp?

thanks, ron

Just found your answer:

declare @v1 int

set @v1 = 25

set rowcount @v1

select * from MyTable Order by DateColumn

set rowcount 0

For a full explanation check this article: