SQLRegionIDSQLLastUpdatedSQLIPAddressSQLEmployeeID
I do not use these fields in the form I have created. The trigger code follows:
CREATE TRIGGER trgInsUpdOffClass ON dbo.OffClass FOR INSERT, UPDATEASUPDATE OffClassSET SQLLastUpdated = GetDate(),SQLEmployeeID = dbo.fnGetContextLogin(),SQLIPAddress = dbo.fnGetMACAddress()FROM Inserted iWHERE i.SQLGUID = OffClass.SQLGUID
The SQLLastUpdated column is causing the collision.
Ideas?
Ben