SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SP RUNS ONCE THEN GETS STUCK IN A LOOP
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

wjunk
Starting Member

6 Posts

Posted - 08/09/2007 :  09:26:42  Show Profile  Reply with Quote
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

USA
299 Posts

Posted - 08/09/2007 :  15:43:03  Show Profile  Reply with Quote
post sample data and table structure along with your code. you will get better response to your post.

Ashley Rhodes
Go to Top of Page

LoztInSpace
Aged Yak Warrior

940 Posts

Posted - 08/10/2007 :  11:11:51  Show Profile  Reply with Quote
Sounds like a dodgy transaction causing a lock. Check your begin trans/commits through the path of the SP or whatever calls the SP.
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000