Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rhsvsmktmaker
Starting Member
1 Post |
 Posted - 2009-05-31 : 17:58:41
|
| I recently migrated databases from SQL Server 2000 to SQL Server 2005 on a virtual server. The websites that point to the new databases are now sporadically receiving a timeout expired error. I have changed the connection timout to 60 and command timeout to 30 but still receiving the same error. Any solution to this prob? |
|
|
SQLRatankalwa
Starting Member
42 Posts |
Posted - 2009-06-02 : 00:22:48
|
| Migrating from SQL Server 2000 to SQL Server 2005 looks like an easy job. But the way the Query engine treats the queries are different.I would recommend you to go through each and every query run it in the management studio and look at the plan or post the query in the post then I would be able to help you out.Ratan KalwaSQL Server Professionals User Grouphttp://www.revalsys.com |
 |
|
|
|
|
|
Timeout Expired