Error: This cache contains no result sets, or the current result set contains no rows.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Programming » SMO/RMO/DMO » Error: This cache contains no result sets,...

Error: This cache contains no result sets, or the current result set contains no rows.

Rate Topic

Display Mode

Topic Options

Author

Message

jeanangeo

Posted Tuesday, September 27, 2005 3:21 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, November 05, 2008 7:33 AM
Points: 5, Visits: 20

Hi all,

Does anyone know what this error means, what causes it and how to fix it?

Exception:
System.Runtime.InteropServices.COMException (0x80045026): [SQL-DMO]This cache contains no result sets, or the current result set contains no rows.
at SQLDMO.QueryResults.GetColumnString(Int32 Row, Int32 Column)
at Mbr.DbGet.DbRestorer.RestoreDatabase()
at Mbr.DbGet.DbRestorerCollection.RestoreAll()

I have created an application that restores a given database. This application works fine on one machine but throws this error on a second machine.

I can't find anything about this error on either google or MSDN.

Can anyone help?

Kindest regards

jeanangeo

Post #223817

Site Owners

Posted Friday, September 30, 2005 8:00 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 18, 2007 3:36 PM
Points: 10,040, Visits: 1

No one has responded to this topic yet. Even if you don't have a complete answer, the original poster will appreciate any thoughts you have!

Post #225187

Jon-413357

Posted Wednesday, February 28, 2007 4:19 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, June 11, 2013 2:31 AM
Points: 9, Visits: 48

I got the same error in:

Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

The error:

http://i16.tinypic.com/2hwjhpx.jpg

While selecting a backup device (file) during a restore of a database, this error occurred in the Enterprise Manager. Previous to this message, the button "select devices..." didn't respond.

I have no clue... anyone?

Post #348075

SEFL

Posted Saturday, May 01, 2010 11:58 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 08, 2012 12:01 PM
Points: 1, Visits: 4

Please forgive me for being tardy to the party (I brought beer, though...honest). But since this just happened to me today and since I was able to figure out at least one possible reason why this behavior occurs, I wanted to share it.

This error message can occur if the folder that contains your backup file has a space in the folder name. To solve the problem, replace the space with a dash (this may work with an underscore as well, although I haven't tried it).

E.g. if your folder path is C:\SQL Backups\, rename it to C:\SQL-backups\.

Hopefully this helps someone. That one little dash can make all the difference (it did for me, anyway.)

Search Engine Friendly Layouts - layout code samples that are both user and search engine friendly.

Post #914261

« Prev Topic | Next Topic »

Permissions