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 |
|
wjunk
Starting Member
6 Posts |
 Posted - 2007-08-09 : 09:26:42
|
| Hi,has anyone ever encountered this problem where they have a stored procedure which runs perfectly fine the first time you run it(takes 14 seconds) but say if i try and run it again afterwards (i.e. 2 mins or 2 hours later) it seems to get stuck in a loop and i have to cancel the job and then start it again which basically means the job is useless.The stored procedure its running is simply updating a view.Any ideas?kind regards |
|
|
ashley.sql
Constraint Violating Yak Guru
299 Posts |
Posted - 2007-08-09 : 15:43:03
|
| post sample data and table structure along with your code. you will get better response to your post.Ashley Rhodes |
 |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2007-08-10 : 11:11:51
|
| Sounds like a dodgy transaction causing a lock. Check your begin trans/commits through the path of the SP or whatever calls the SP. |
|
|
|
|
|
|
SP RUNS ONCE THEN GETS STUCK IN A LOOP