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 |
|
john20
Starting Member
30 Posts |
 Posted - 2006-09-15 : 06:16:10
|
| Hi All, we are working on Sql2000 and while doing transaction we are getting Timeout Expired Error. pls provide some help... Thanks in Advance, Regards, john |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-09-15 : 07:08:11
|
| Too short problem description...!!1. Are you getting Timeout error in db or at front-end?2. Post the code which is the suspected culpritHarsh AthalyeIndia."Nothing is Impossible" |
 |
|
|
anilkdanta
Starting Member
25 Posts |
Posted - 2006-09-15 : 07:30:25
|
| Yes, you need to post relevant details.But I guess your time out problem is occuring at database server.Verify the code in Transaction for any memory intensive queries involving large tables. The reason can be the tables it is querying are locked by some other process, or a possible dead lock situation. Run the sp_who or sp_who2 in Query Analyzer to see process information. |
|
|
|
Luis Martin
Yak Posting Veteran
54 Posts |
Posted - 2006-09-15 : 10:22:22
|
| Did you know what query is doing this?.If yes, then try to optimize looking execution plan. |
|
|
|
|
|
|
Timeout Expired Error....