Recently we migrated objects in SQL Server 7.0 to SQL Server 2000. We use SQL tables in 'MS Access 2000' queries by linking those tables to the Access MDB file. After the migration, a query accessing this SQL table is running for a long time and it never completed, so i had to cancel the query half way always.
This is weird and I have no idea why this is happening after migrating to SQL Server 2000. The same query was taking few minutes to complete, when it was using an object in SQL Server 7.0.
Can any one of you help me to figure out the cause for this problem?