September 10, 2009 at 8:07 am
When I tried to execute 'sp_OAMethod' procedure in SQL 2005, i got the error as '[SQL-DMO] This cache contains no result sets, or the current result set contains no rows.'
The 'sp_OAMethod' procedure we executed as follows:
sp_OAMethod @objQueryResults, 'CurrentResultSet', @objCurrentResultSet OUT
I also enabled 'Ole Automation' from Surface Area Configuration.
Please give a solution for this.
September 10, 2009 at 9:57 am
Where are you defining and instantiating @objQueryResults? You cannot call methods until you have an instantiated object.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply