Home Forums SQL Server 2005 Administering Getting an error "Exception of type 'System.OutOfMemoryException' was thrown." during stored procedure execution RE: Getting an error "Exception of type 'System.OutOfMemoryException' was thrown." during stored procedure execution

  • What do these queries return?

    SELECT COUNT(1) FROM msdb.dbo.backupfile;

    SELECT COUNT(1) FROM msdb.dbo.backupfilegroup;

    SELECT COUNT(1) FROM msdb.dbo.restorefile;

    SELECT COUNT(1) FROM msdb.dbo.restorefilegroup;

    SELECT COUNT(1) FROM msdb.dbo.restorehistory;

    SELECT COUNT(1) FROM msdb.dbo.backupmediafamily;

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]