Row cannot be located for updating error when triggers are in use

Problem Description

When using AspGrid with SQL Server, and the database table uses triggers, the following errors may occur:

AspGrid Update Error. Row cannot be located for updating. Some values may have been changed since it was last read.

AspGrid Insert Error. Row cannot be located for updating. Some values may have been changed since it was last

Solution

Modify your trigger(s) as follows:

Set nocount on

(rest of trigger)

Set nocount off