Hey, Evan,
At the risk of self-promotion....
http://www.code-magazine.com/Article.aspx?quickid=0503071(one of the 13 tips deals with audit trail processing and triggers).
I also have an article in the premier .NET UT mag on T-SQL code in 2005.
While neither article explicitly talks about moving from VFP to SQL Server, they might be helpful.
Kevin