Hi,
I have a problem with transactions. There is an SQL 2000 server machine and there is 2 clients. If one client do the following:
BEGIN TRANSACTION
INSERT INTO any_table (field1) values ('any value')
the another client cannot query the table until the transaction is committed (or rollbacked). Why? What kind of feature is this, or any settings?
(Sorry if it is a trivial thing, but I cannot understand...)
A8
I have a problem with transactions. There is an SQL 2000 server machine and there is 2 clients. If one client do the following:
BEGIN TRANSACTION
INSERT INTO any_table (field1) values ('any value')
the another client cannot query the table until the transaction is committed (or rollbacked). Why? What kind of feature is this, or any settings?
(Sorry if it is a trivial thing, but I cannot understand...)
A8