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

• jeanangeo

  SSC Veteran

  Points: 207

  More actions

  September 27, 2005 at 3:21 am

  #89077

  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

• JonnoJ

  SSChasing Mays

  Points: 632

  More actions

  February 28, 2007 at 4:19 am

  #692262

  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?

   

   

• SEFL

  SSC Journeyman

  Points: 83

  More actions

  May 1, 2010 at 11:58 am

  #1160923

  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[/url] - layout code samples that are both user and search engine friendly.