Hi TristaanOgre,
This is what I would essentially be be doing:
function GeneralEvents_OnLogError(Sender, LogParams)
{
testStatusComments = LogParams.AdditonalText
var dbObj;
dbObj = ADO.CreateADOQuery();
dbObj.ConnectionString = "MyConnectionString";
dbObj.SQL = "Update Test_Status set testStatusComments = testStatusComments + '" + testStatusComments + "' Where TestSectionName = '" + testname + "' AND TestStartTime Like '%" + TestDate + "%'";
dbObj.ExecSQL();
}
This will add to other information currently being written out to SQL on the start and stop events.
The eventual aim is to start using reporting services so that we can can see very quickly if there are any patterns in failure.