Hi,
I’ve got a proc on a server which I am trying to run from the other server.
There are no linked servers and I want to avoid linked servers.
I have tried to use openrowset which I have used in many other occasions.
select * from OPENROWSET('SQLOLEDB','ServerA';'user';'password', 'exec testdb..testproc ''Summary'',''longdesc''')
and I will get The OLE DB provider 'SQLOLEDB' indicates that the object has no columns. Error message. This is down to the openrowset checking the meta of the proc prior to running it
so I have tried to use
set FMTonly on
to disable it but still it doesn’t work.
Any idea how I can get around this problem?