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 |
|
maevr
Posting Yak Master
169 Posts |
 Posted - 2010-11-17 : 05:25:26
|
| In my production database a stored procedure is all of a sudden causing a lock that lasts several hours, but eventually everything is fine. SQL 2005 stdI have a development database that is a exact copy of the production database and here everything works ok. SQL 2008 stdWorth mentioning is that this stored procedure has been working for several years without problemsThe stored procedure is using a view to update 290 rows in a table.Any tips would be appreciated! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
procedure causes lock