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.
| Author |
Topic |
|
LearnSQL
Starting Member
12 Posts |
 Posted - 2001-09-06 : 12:21:24
|
| Hi again!We have a situation where system should keep an audit trail of every inserts, updates, and deletes in a table (statement done in both application side as well as backend side). The problem is that one of column is TEXT data type and trigger's "inserted" and "deleted" would not allow TEXT data type.Unfortuanately, there are several datalength(text) over 30,000. We have:CREATE TABLE dbo.Content(CID int NOT NULL,DESCRPT text NOT NULL)CREATE TABLE dbo.TrackData(ActivityID IDENTITY (1, 1) NOT NULLPID int NULL,CID int NULLDescrpt text)Every time INSERT, UPDATE, or DELETE command is executed, we want to insert a row in TrackData table. Trigger is being used to perform this task, but we are kinda stumped when trigger is fired as to how whole TEXT content can be inserted into TrackData table.Any help you can give will be very much appreciated!Thanks! |
|
|
|
|
|
TEXT data type