We have SQL Server 7.0 . 2 users are trying to update simultaneously a table called as employee thru Cold Fusion.
Only one of the updates work. The other update does not work but it does not give any error either.
Also both the users are trying to update different recordsets in the employee table.
Do you know if there is a problem with simultaneous updating of a table in SQL Server 7.0. Also, we just have SQL Server 7.0 that we installed from CD-ROM. We did not apply any patches later.
Thanks for the help.
Only one of the updates work. The other update does not work but it does not give any error either.
Also both the users are trying to update different recordsets in the employee table.
Do you know if there is a problem with simultaneous updating of a table in SQL Server 7.0. Also, we just have SQL Server 7.0 that we installed from CD-ROM. We did not apply any patches later.
Thanks for the help.