"for xml" via rpc - why do I receive binary data?

Hi,

I guess this is an old topic but I looked and could not find a clue: I
have a stored procedure "xmlproc" on "sqlserver_A", which returns xml
via a "select ... for xml auto" query. "sqlserver_B" is linked to
sqlserver_A (I tried to link as "SQL Server", "Native Client" and
"OLEDB") and calls

exec sqlserver_A.mydb.dbo.xmlproc

But instead of returning xml data, I receive a binary string that
looks like

0x440C690064005F0050006F0072007...

Is there anyway around this?

TIA, Regards
DC
.

Relevant Pages

  • Re: python for loop
    ... Python (because a user would have NO CLUE that something underlying ... the needless abuse of exec. ... recklessly using exec like he owns the language ...
    (comp.lang.python)
  • What does the capital "N" signify?
    ... exec sp_dboption N'ACME', N'autoclose', N'false' ... Hey all, as referenced above, this is code autogenerated by .NET. ... Just irks me because I have no clue what it's doing. ...
    (microsoft.public.dotnet.languages.vb)
  • What does capital "N" do, exactly?
    ... exec sp_dboption N'ACME', N'autoclose', N'false' ... Hey all, as referenced above, this is code autogenerated by .NET. ... Just urks me because I have no clue what it's doing. ...
    (microsoft.public.vb.general.discussion)
Loading