SQL Error 2417 driving me nuts 
Author Message
 SQL Error 2417 driving me nuts

Hi all,

I have this stored procedure which takes a snap shot of a users data
available to them, then updates the data stored in the our #temp table,
and then returns the modified data set to the java client that invoked
the call. Unfortunately,  we still have sites running SQL 6.5 and SQL
7.0, with no immediate chance of upgrading to SQL 2000.

At any given site, there could be up to fifty java clients, who poll the
database at a given interval. This polling invokes the stored procedure
that is causing me problems. In the event that two or more clients
simultaneously invoke this stored proc call, then whichever client wins
the race, prevents the others from retrieving the data due to the
existence of the #temp objects.

I am more that happy if someone would like a copy of the proc in its
current form for comment. Any suggestions would be gratefully
appreciated.

Regards

Gary Jones.

*** Sent via Developersdex http://www.***.com/ ***
Don't just participate in USENET...get rewarded for it!



Sun, 25 Jun 2006 17:41:07 GMT
 SQL Error 2417 driving me nuts

Gary,

More detail is needed here, such as the script of the stored procedure.
Perhaps you might also toss in some DDL so we can get a grip on this.

James Hokes


Quote:
> Hi all,

> I have this stored procedure which takes a snap shot of a users data
> available to them, then updates the data stored in the our #temp table,
> and then returns the modified data set to the java client that invoked
> the call. Unfortunately,  we still have sites running SQL 6.5 and SQL
> 7.0, with no immediate chance of upgrading to SQL 2000.

> At any given site, there could be up to fifty java clients, who poll the
> database at a given interval. This polling invokes the stored procedure
> that is causing me problems. In the event that two or more clients
> simultaneously invoke this stored proc call, then whichever client wins
> the race, prevents the others from retrieving the data due to the
> existence of the #temp objects.

> I am more that happy if someone would like a copy of the proc in its
> current form for comment. Any suggestions would be gratefully
> appreciated.

> Regards

> Gary Jones.

> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!



Sun, 25 Jun 2006 18:19:36 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. JDBC Errors are driving me nuts!!!

2. Error 3030 is driving me nuts!

3. asa error message driving me nuts

4. Error 11 is driving me NUTS!

5. Error 1756 driving me nuts!

6. Error 2009 Driving Me Nuts!

7. DTS from ASP security driving me nuts!

8. Driving me nuts!!

9. Triggers drive me NUTS!

10. I'm sure it something simple but it's driving me nuts :-(

11. Synax problem driving me nuts

12. HELP: isql is driving me nuts!


 
Powered by phpBB® Forum Software