Well, I got the copy-to-FoxPro trigger on the local SQL table to work!  It was just a matter of hitting on the right...

Further to my initial post.

I gave up trying to get the trigger to work on the view.  I created a copy of the FoxPro table on the SQL server and...

In a desperate effort to debug a trigger, I have sent an email from the triggered event.

I created my own sp to build the email using CDONTS, then called that...

Oops.  I found the problem myself - persistence is the key.  I omitted the "New" keyword when I declared the DataSet variable.