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 |
|
cvsubbarao
Starting Member
2 Posts |
 Posted - 2004-11-15 : 17:04:07
|
| I have order table which has more than 600000 records. I could not update one particular record even from "Query Analyzer". Even I tried with Enterprise manager. The select query works fine but any update on the particular record fails and getting timeout error(80040e31). The particuar record created on 11/10/2004. I updates other records after that date without any problem.Can any one help me in this?ThanksSura |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-11-16 : 00:32:21
|
| Please post the SQL you are usingKristen |
 |
|
|
cvsubbarao
Starting Member
2 Posts |
Posted - 2004-11-19 : 11:11:06
|
| It is simple sql queryIt is Sqlserver 2000update orders set ship=1 where orderid=182523only that particular orderid has not updated. I have no problem with all other orderids |
|
|
|
brendalisalowe
Constraint Violating Yak Guru
269 Posts |
Posted - 2004-11-19 : 12:12:19
|
| Is orederid an integer?BrendaIf it weren't for you guys, where would I be? |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2004-11-19 : 20:07:08
|
do you have some foregin key that gets violated when you try to update it?what error do you get?Go with the flow & have fun! Else fight the flow  |
|
|
|
|
|
|
can not update a particular record in the table