May 14, 2004 at 2:00 pm
I'm not sure if anyone can help. I've written xp_gcquery to login to a remote server and run usp_gc_query and return the resultset (which consists of 1 row/field - valid_amt) to the calling server. I'm not sure what I'm missing but I usually end with an error on the transaction from the xp. Here's how I'm testing it:
exec master..xp_gcquery @rmtServer = 'DEV-SEA-SQL-01',
@rmtUser = 'test', @rmtPwd = 'testing', @rmtProc = 'dbo.usp_gc_query',
@eMail = 'test', @batchID = 101, @GC_number = '017502',
@GC_original_amount = 35
May 14, 2004 at 2:07 pm
Can you post the error you recieved?
May 14, 2004 at 2:11 pm
This is the error:
Msg 20001, Level 1, State 20001
Error executing extended proc: Remote procedure execution failed with rollback.
I'm sure this doesn't help much without going into the c++ of the xp, but I'd like to at least get verification that my "calling" procedure is correct.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply