> I'm getting the following error when trying to call a stored procedure
> with parameters as a table in a select statement:
> Server: Msg 7357, Level 16, State 1, Line 1
> Cannot process the object ....... The OLE DB provider "SQLNCLI" for
> linked server "(null)" indicates that either the object has .........
>
> Here is my sql statement:
> select *
> FROM OPENROWSET
> ('SQLNCLI','server=<srvr>;Trusted_Connection=yes;','SET FMTONLY
> OFF;exec <server>.(database>.dbo.<storedprocedure> ''<string
> parameter>'',<int parameter1>,<int parameter2>'
> )
> AS tbl

On Jul 10, 6:56 pm, Erland Sommarskog <esq...@sommarskog.se> wrote:
> aron (aron.felberb...@gmail.com) writes:
> > I'm getting the following error when trying to call a stored procedure
> > with parameters as a table in a select statement:
> > Server: Msg 7357, Level 16, State 1, Line 1
> > Cannot process the object ....... The OLE DB provider "SQLNCLI" for
> > linked server "(null)" indicates that either the object has .........
>
> > Here is my sql statement:
> > select *
> > FROM OPENROWSET
> > ('SQLNCLI','server=<srvr>;Trusted_Connection=yes;','SET FMTONLY
> > OFF;exec <server>.(database>.dbo.<storedprocedure> ''<string
> > parameter>'',<int parameter1>,<int parameter2>'
> > )
> > AS tbl
>
> Why not run the procedure with a four-part form:
>
> EXEC Server.database.dbo.storedprocedure
>
> If you need to use the result in a query, user INSERT-EXEC. The SET FMTONLY
> trick is not without problems - it means that the procedure is executed
> twice.
>
> --
> Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se
>
> Books Online for SQL Server 2005 athttp://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books...
> Books Online for SQL Server 2000 athttp://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

>> Why not run the procedure with a four-part form:
>>
>> EXEC Server.database.dbo.storedprocedure
>>
>> If you need to use the result in a query, user INSERT-EXEC. The SET >>
>> FMTONLY trick is not without problems - it means that the procedure is
>> executed twice.
>
> Tried the following and I'm getting the same error
> select * FROM OPENROWSET
> ('SQLNCLI','server=srvr;Trusted_Connection=yes;','exec
> Server.database.dbo.storedprocedure ''xxxxx'',999,-99') AS tbl