sql server programming: Error 311 -- sql server programming

Error 311

Bush
8/21/2003 11:14:10 PM

sql server programming: Hi,
I need to audit a column with Text datatype. SQL Server
does not allowing me to use Text datatype with
inserted/Deleted tables.
I know this can be accomplished by using instead of
trigger. But I need to update the base table and insert
old 'n' new values (Text datatype) in Audit table.

Please help me.

Thanks in advance....

Re: Error 311

SriSamp
8/22/2003 12:28:32 PM

We have a similar problem in our application. Triggers cannot refer to TEXT
columns in the pseudo-tables.
One solution that we adopted was to write the auditing code ourselves. For
example, in a stored procedure that inserts into a table, we also do an
insert into the audit table.
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp

[quoted text, click to view]