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 c
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
Matt Small
-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 = = =
> 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 th
il 26, 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 ser
[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 no
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
8 matches
Mail list logo