Post reply

Can't query after SQL 2005 Upgrade

  • October 2, 2009 at 8:07 am

    #142270

    We recently moved a database from SQL 2000 to 2005. The database in question must run in 2000 compatibility mode, which it is. Everything during the upgrade went well and the application is working just fine in the new environment. But...

    There are several Crystal reports in the application that will not return data. They just run indefinitely. They all reference the same view. Other reports that do not reference that view work fine. Furthermore, I can not even run a simple select statement against that view. The statement simply runs and runs.

    The reports and the select statement work just fine in the old 2000 environment. I'm stumped, can anyone offer a suggestion?

    Thanks in advance.

  • October 2, 2009 at 8:10 am

    #1060954

    Can you rebuild your indexes and see if the performance improves.


    Pradeep Singh

  • October 2, 2009 at 9:14 am

    #1061000

    Thanks. Should I rebuild all indexes or only those on the tables used in this specific view?

  • October 2, 2009 at 9:45 am

    #1061031

    You may also want to check syntax of your view definition and see if it still compatible with SS2005 - there were several syntax discontinuation there.

  • October 5, 2009 at 7:42 am

    #1061715

    Update:

    The syntax is compatible. Other organizations have successfully used this same view in the vendor DB in a sql 2005 environment in 2000 compatibility mode.

    Last night we rebuilt all indexes.

    The issue still exists 🙁

    Any other ideas?

  • October 5, 2009 at 8:00 am

    #1061736

    Brett Favre (10/5/2009)

    Update:

    The syntax is compatible. Other organizations have successfully used this same view in the vendor DB in a sql 2005 environment in 2000 compatibility mode.

    Last night we rebuilt all indexes.

    The issue still exists 🙁

    Any other ideas?

    Did you UPDATE statistics. This could be the culprit most of the time. I have seen several good discussions about that here but dont have the link at this moment. One that I can see could be useful for you is this,

    http://www.sqlservercentral.com/Forums/Topic778825-360-1.aspx

    But I guess updating statistics is worth trying as a first step!

    ---------------------------------------------------------------------------------

  • October 5, 2009 at 8:11 am

    #1061745

    Yes, statistics were updated after the indexes were rebuilt.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply