RE: cflock over multiple servers.

2002-04-18 Thread cameronc
No. CFLOCK (and all other tags) run locally on each server, and are not aware of other CFLOCKS on other CF servers. If you want them to all wait in line, the best solution may be to use a CFTRANSACTION around your table check to block the other servers out of that DB table/row till your DB ti

cflock over multiple servers.

2002-04-18 Thread mynews
I have 3 mirrored servers accessing the same SQL-Server DB. They are all running an agent that retrieves news and weather. For redundantcy, They are each running the agent. I have set up a table that keeps track of the last time the agent ran and each server will check the table first before t