can u plz help me in doing this. I have to create a transaction log of each and table of the database in a log table for each. Some tables have columns of text, ntext, even image type. While working with a trigger it tells that trigger can't be created on tables having the above specified data type columns. I have tried with INSTEAD OF trigger but it copies the data to the LOGTABLE instead of the base table. So, the inserted data is not available in the base table though someone has inserted that. So, plz help me.

-- Anonymous, February 24, 2004

Answers

Pinakee,

Query the original table, joining with the PK value from INSERTED/DELETED, to get the BLOB data.

Hope this helps,

Eric

-- Anonymous, February 27, 2004

Yes, Quering the Original table Does Help. Take other data from the INSERTED (or DELETED) table Except the TEXT/NTEXT data. This is Because Sql server will not store the IMAGE data type in INSERTED/DELETED tables due to their Large Size.

Vineet

-- Anonymous, September 03, 2004