Hello!

Sorry for the delay. Had some other issues a few days, but now I'm back online.
I still think I should use the triggers, If I could solve this problem.
Yes, the problem still exists. I will below add a routine for reproducing the problem.
I would be very glad if you can help me, because this is very annoying for me.

1. Create a database called UpdateTriggerProblem (this was made using MS SQL Server 2000)
2. Add a table named MyTbl with the three columns CustID (varchar(50) Primary key), CustName(varchar(50)), ChangedDate(datetime)
3. Add a trigger as follows

CREATE trigger [tri_MyTbl_update] on dbo.MyTbl for update as
 declare @ID varchar(50)
 select @ID=(select [CustID] from inserted)
 update [MyTbl] set ChangedDate=GetDate()
 where [CustID]=@ID

2. Create a new VB application with a form.
2. Add a datagrid and a button to the form
3. Add the code below in the form code

Dim ds As New DataSet
Dim cn As New SqlClient.SqlConnection("integrated security=SSPI;data source=localhost;initial catalog=UpdateTriggerProblem")
Dim da As New SqlClient.SqlDataAdapter("select * from MyTbl", cn)
Dim cb As New SqlClient.SqlCommandBuilder(da)
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
da.Fill(ds, "MyTbl")
DataGrid1.DataSource = ds.Tables("MyTbl")
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If ds.HasChanges Then
cb.RefreshSchema()
da.Update(ds, "MyTbl")
End If
End Sub

4. Change the data source at second row (localhost) if necessary.

Now it is ready for testing. To test the project do as follows (always change the rowfocus before pressing the button).
1. Run project
2. Add the first row by adding values in CustID and CustName, and press the button
3. Change the CustName, and press the button
4. Do the 3:rd item again, and again if necessary

You should have got the problem by now.

Best regards Magnus