I asked this last week and I wasn't sure about the answer.
I have 3 computers accessing a SQL-server at the same time. I
need the DB to be locked so they can't read/write the data at
the same time. How do I get the servers to get in line and
wait for each other?
BJ
I have 3 computers accessing a SQL-server at the same time. I
need the DB to be locked so they can't read/write the data at
the same time. How do I get the servers to get in line and
wait for each other?
Almost all databases provide that functionality automatically. If one
database client
The problem is that each Server has to read and THEN write before
the next one reads. Any ideas?
BJ
= = = Original message = = =
I have 3 computers accessing a SQL-server at the same time.
I
need the DB to be locked so they can't read/write the data
at
the same time. How do I get the
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 26, 2002 10:13 AM
To: CF-Talk
Subject: RE: will cftransactoin work?
The problem is that each Server has to read and THEN write before
the next one reads. Any ideas?
BJ
= = = Original message = = =
I have
The problem is that each Server has to read and THEN write
before the next one reads. Any ideas?
If you have multiple queries that need to be treated as a single
transaction, then you can use CFTRANSACTION to group those queries, or write
transactional logic in a stored procedure and call
, 2002 8:30 AM
To: CF-Talk
Subject: will cftransactoin work?
I asked this last week and I wasn't sure about the answer.
I have 3 computers accessing a SQL-server at the same time. I
need the DB to be locked so they can't read/write the data at
the same time. How do I get the servers to get
[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
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
8 matches
Mail list logo