mnavahan wrote:

>
> i also i change online some procedure and define new table when user (3
> to 15 user) connect to my database .can this work do database
> corruption ?

There used to be an issue if you did a DDL and a DML in the same transaction

ie.
start transaction;
alter table foo add bar varchar(10);
update foo set bar = 'TEST';
commit;

Not sure if this still applies, but I had messed up my data nicely when I did this a while back.

FWIW
Gary

[Non-text portions of this message have been removed]