hi i write a trigger for auditing changes on my tables

take a look at it

CREATE TABLE [TBAudit](

[ID] [int] IDENTITY(1,1) NOT NULL,

[TableName] [nvarchar](150) NULL,

[PK] [nvarchar](500) NULL,

[Kind] [tinyint] NULL,

[Usr] [nvarchar](100) NULL,

[Application] [nvarchar](100)...