Hi,
Im running into a strange problem here!
I have created a linked server on one of my SQL Servers (local server).
Lets call the linked server as LS1.
I have an sproc which resides on the remote server(LS1) and uses a FOR
XML query.
On running this sproc from my local server using linked server LS1, I
get a strange serialized data as output instead of the usual XML
output.
I run the proc as
exec [LS1].[DBName].[UserName].[SprocName] '12/1/2004','12/3/2004'
the proc accepts 2 parameters as dates.
The output generated is smth like:
0x44046E0061006D0065004404440061.......(long string of hex codes)
Looks like the ouput is getting serialized. How can I avoid
serialization OR How to de-serialize this data?
Please Help
Thanks,
Geo