private static SqlDataRecord buildRecord(SqlMetaData[] metadata,EventLogEntry entry) { SqlDataRecord record = new SqlDataRecord(metadata); record.SetSqlInt32(0, entry.Index); record.SetSqlInt64(1, entry.InstanceId); record.SetSqlDateTime(2, entry.TimeWritten); record.SetSqlString(3, entry.MachineName); record.SetSqlString(4, entry.Source); record.SetSqlString(5, entry.UserName); record.SetSqlString(6, entry.Message); return record; }
private static void SendCommandStatus(SqlPipe pipe, SqlInt32 status, SqlString substatus) { SqlDataRecord rec = new SqlDataRecord( new SqlMetaData("Status", SqlDbType.Int) , new SqlMetaData("SubStatus", SqlDbType.NVarChar, 150) ); SqlContext.Pipe.SendResultsStart(rec); rec.SetSqlInt32(0, status); rec.SetSqlString(1, substatus); pipe.SendResultsRow(rec); pipe.SendResultsEnd(); }