• First I have to admit that I’m shooting in the dark because I haven’t seen SQL Server 6.5 for many years. After you upgrade the server to SQL Server 2000 make sure that your database’s compatibility level is set for SQL Server 2000. You can use the GUI or sp_dbcmptlevel. Only after you modify the compatibility level to SQL Server 2000, backup the database and then try to restore it to SQL Server 2005,

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/