I am attempting to write a trigger which will copy a row from a table to an indentical table on another database. The trigger fires when a bit is checked a resets the bit back to 0. All data can be written to the second table with the exception of BLOB data (a TEXT field); it is not written to the Inserted table, nor can the info be stored in a variable or updated with an update based on a collateral query of the info field.