SQL Server Performance

Error: Failed to retrieve data from the database. Details: [Database Vendor Code: 245]

Discussion in 'SQL Server 2008 General DBA Questions' started by riveroat, Nov 2, 2009.

  1. riveroat New Member

    hi all,
    I have an issue with a report in Crystal Report, whichsometimes runs and sometimes not (Error: Failed to retrieve data from thedatabase. Details: [Database Vendor Code: 245]), when not running what we do isend the process of SQL Server in the Task Manager and started it by Services,run the report again and it works.
    This report was developed in SQL Server 2000 and migrated toSQL Server 2005.
    When running in SQL Server 2000 was not error.
    any hints on isolating the issue?
    riveroat, Nov 2, 2009
    #2

  2. melvinlusk Member

    So, when the report fails to run, you're actually terminating the SQL Server process in Task Manager and then restarting the service? This is suicide, and can cause some serious issues with your databases.
    When trying to run the report, do you get the error, and then try again and get the same error? Have you tried to view the SQL Server or Windows event logs for more information?
    When running the report, how long does it run before you get this error?
    melvinlusk, Nov 9, 2009
    #3

  3. ghemant Moderator

    Hi,
    Welcome to the Forums [:)]
    If you have upgrade your server or migrated your database to the SQL Server 2005 from SQL Server 2000, there are certain things you have to check they are:
    1. Have you run reindex Or have you run index defrag (followed by statistic update)
    2. Ensure that the execution plan are same for both
    ghemant, Nov 12, 2009
    #4

Share This Page