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 |
|
prodigy2006
Yak Posting Veteran
66 Posts |
 Posted - 2009-10-01 : 07:35:21
|
| I got a script from a developer with an update statement. The script had errors as there was primary key violation but the next thing i hear from the developer is the table got locked. When i looked at the Activity monitor, everything seemed fine. I'm not really sure how should i troubleshoot this issue.Thanks,Sunny |
|
|
prodigy2006
Yak Posting Veteran
66 Posts |
Posted - 2009-10-01 : 11:19:34
|
| Can someone please reply how to troubleshoot this issue? |
 |
|
|
prodigy2006
Yak Posting Veteran
66 Posts |
Posted - 2009-10-01 : 16:45:08
|
| Can someone help me solve this?Thanks,SUnny. |
|
|
|
prodigy2006
Yak Posting Veteran
66 Posts |
Posted - 2009-10-02 : 17:05:19
|
| I'm trying to figure out if my question is stupid or smart?I'd realy appreciate if you guys could help me out. |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-10-02 : 17:17:56
|
quote:
I got a script from a developer with an update statement
Typically this is a bad sign.quote:
The script had errors as there was primary key violation
This is not necessarily a script error, nor even an error, simply an issue with the data being updated. However, since it's the primary key being violated, it probably is a script error.quote:
but the next thing i hear from the developer is the table got locked
The developer doesn't know what they're talking about.quote:
I'm not really sure how should i troubleshoot this issue.
You'll need to post the structure of the table(s) involved and the script that's doing the update. |
|
|
|
|
|
|
Table got locked