Microsoft Fixes Access-Violation Exception in SQL Server 2000

Microsoft has released a hotfix for an access-violation exception that might occur when multiple users try data modification operations at the same time. When you’re working in a multi-user environment and you connect to an instance of SQL Server 2000 that’s running on a symmetric multi-processor (SMP) computer, an access violation might occur when multiple users try to perform data modification operations, such as an UPDATE operation, on the same SQL Server table at the same time; when one or more triggers are defined on the SQL Server table that corresponds to the data modification operations; and when one or more triggers access the inserted table, the deleted table, or both. This behavior doesn’t occur frequently because it depends on the time difference between the data modification operation and the log scan operation, which is a small time difference. To learn more about the problem and the supported hotfix, read the Microsoft article “An access violation exception may occur when multiple users try to perform data modification operations at the same time that fire triggers that reference a deleted or an inserted table in SQL Server 2000 on a computer that is running SMP.”
   http://support.microsoft.com/?kbid=873446