SIMPLE SQL QUERY'S TIMING OUT

[dkwaters]

I have two identical SQL databases, one on SQL sevrer 2000, one on SQL server 7. The 2000 version works fine, however simple querys that run in seconds on the 2000 version time out on the sql 7 version. I have checked all the indexes and they are identical, checked the disc space and checked the log file. The problem does not seem to be table specific and occurs on the smallest of tables. I am at a bit of a loss as what to look into next, and suggestions would be greatly appreciated.

 

[Udayk100]

If its a select....try with (nolock) hint...
Look at the execution plan on the sql server 7.0..
That might help you...

May be drop and recreate y'r non clustered index...

 

[krotha]

This may help

set implicit_transactions may be on and You may not issue the commit or rollback a transaction.

Issue a rollback or commit in query analyzer and try.