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 |
|
yadhu_cse
Constraint Violating Yak Guru
252 Posts |
 Posted - 2011-03-29 : 03:14:45
|
Hi,I have defined ON DELETE CASCADE constarint on 8 to 10 table.when i execute application in testing it works fine. when i execute application in live its giving time expired.The timeout period elapsed prior to completion of the opration or the server is not responding.. Can any one help this regard. whole application works fine but when i choose on that option its giving error.![]() |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-03-29 : 07:16:56
|
| Assuming you are sending the delete command from a client application, you can increase the command timeout. In ADO.Net, for example, the command timeout is 15 seconds by default. SqlCommand.CommandTimeout property lets you increase it if you like. You can even have no timeout if you set it to 0.BUT, usually the command time out is an indication of some other problem. Were you experiencing significant time for the command to complete in your test environment? |
 |
|
|
|
|
|
Time expired error