<div>
Sorry for leaving this so long but I never actually tried the solution.<br />
We ended using a different approach at the business level so ended up not needing this.<br />
<br />
I'm accepting it as it could be a cause.<br />
<br />
Thanks,<br />
Alex
</div>


Sorry for leaving this so long but I never actually tried the solution.
We ended using a different approach at the business level so ended up not needing this.

I'm accepting it as it could be a cause.

Thanks,
Alex

<div>
just happened across this, and thought you might like to see how :<br />
<br />
select * from openrowset('SQLNCLI', 'Server=MY_SVR_NAME;Truste<wbr />d_Connecti<wbr />on=yes;','<wbr />EXEC MY_DB_NAME..USP_MY_SP null,null,null,null') a<br />
<br />
<br />
Now, it will fail unless the stored procedure does have a predefined (ie at create sp time) list of columns. It is quite &quot;sensitive&quot; (read fussy).
</div>


just happened across this, and thought you might like to see how :

select * from openrowset('SQLNCLI', 'Server=MY_SVR_NAME;Trusted_Connection=yes;','EXEC MY_DB_NAME..USP_MY_SP null,null,null,null') a


Now, it will fail unless the stored procedure does have a predefined (ie at create sp time) list of columns. It is quite "sensitive" (read fussy).

<div>
<div class="content wysiwyg-content">
Hi, I'm using SQL SERVER 2005...<br />
is it possible to use OPENROWSET with a EXEC command?<br />
<br />
Something like:<br />
<br />
SELECT *<br />
FROM OPENROWSET('SQLOLEDB','loc<wbr />alhost';'s<wbr />a';'P@ssw0<wbr />rd',<br />
'sp_executeSQL N''MyDataBase..sp_GetMyDat<wbr />a 2008, null, 4'' ') TblA<br />
<br />
Strangely enough (or not) this doesn't work :)<br />
<br />
Is it possible to make it work?<br />
<br />
Thanks,<br />
Alex
</div>
</div>


Hi, I'm using SQL SERVER 2005...
is it possible to use OPENROWSET with a EXEC command?

Something like:

SELECT *
FROM OPENROWSET('SQLOLEDB','localhost';'sa';'P@ssw0rd',
'sp_executeSQL N''MyDataBase..sp_GetMyData 2008, null, 4'' ') TblA

Strangely enough (or not) this doesn't work :)

Is it possible to make it work?

Thanks,
Alex

OPENROWSET and EXEC...

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.