Hi there,

Yes, it's a domain account...and both servers are on the same domain.

Also, yes, this domain account has got access to both server - and the relevant tables on both...

Try putting the "order by" clause inside the inner query.

And there's no "Now" in SQL, try GetDate()

Yes, I do.

Sorry, I meant to say that...   

When I log in as "sa" (or another user which I've set up on both databases) and...