Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  Transact-SQL (2000)  Text fields in triggers

Author  Topic  gerrey Starting Member 5 Posts Posted - 2001-11-15 : 10:56:29 I am creating triggers to log data, ex. table logFoo is updated when foo is updated. All is well for tables that don't have text fields in them. I read that text fields can't be accessed from the deleted table. So I am assuming that I have to do all my updates from a stored procedure, rather than a trigger like all the other tables. a) is it possible to do this in a trigger, if so, how? b) I have surmised that one must use TEXTPTR, READTEXT & WRITETEXT. I can't seem to read the data from table foo and write it somewhere else (in a trigger). What is the syntax for that? TIA Mary-Catherine Gerrey