Sure. I am using SQL_server 2000. The servers are all mirrored and they run update agents every so often. The table in question shows which agents ran at which times. I only want a server to run an agent if that agent hasn't run in X minutes. So the servers check to see when it ran last if it is past X minutes the server will update the LastRun time and run the agent.
This is all to prevent each server from running each agent each time. BJ = = = Original message = = = [EMAIL PROTECTED] wrote: > The problem is that each Server has to read and THEN write before > the next one reads. Any ideas? Why? Most databases provide some sort of build in functionality to do this for the obvious reason (automatic incrementing of a primary key field). So you must have a non-obvious reason to do this. Could you elaborate on what you want to do? And perhaps telling us what dbms you are using would help as well. Jochem ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists