Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
1fred
Posting Yak Master
158 Posts |
 Posted - 2003-01-29 : 16:06:01
|
| I search a few topics and wrote this:select a.* from openrowset('SQLOLEDB','server';'user';'pass', 'exec database.dbo.sp_QEstimationCalcultationSP') AS aWhen I execute this I have this message:Could not process object 'exec database.dbo.sp_QEstimationCalcultationSP'. The OLE DB provider 'SQLOLEDB' indicates that the object has no columns.any Idea? when I just write exec database.dbo.sp_QEstimationCalcultationSP it works fine. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-01-29 : 16:53:34
|
| try putting set nocount onat the top of the SP. I've come across this before - can't remember if this was the solution.Have you thought about creating a linked server andexec linkedserver.database.dbo.sp_QEstimationCalcultationSP==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
1fred
Posting Yak Master
158 Posts |
Posted - 2003-01-29 : 17:08:37
|
| Yes, just "set nocount on" was the solution |
|
|
|
|
|
|
Select Rows from a SP