ALSO - YES, I WOULD BE HAPPY WITH A NON - DYNAMIC SQL SOLUTION

REQUIREMENTS

AFTER EACH UPDATE, INSERTION, OR DELETE

I NEED TO CAPTURE ALL INFO IN RECORD BEFORE CHANGE, ALL...

My audit table (for history of District)

USE [JuryDB]

GO

/****** Object: Table [dbo].[a_District] Script Date: 04/17/2008 09:14:52 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[a_District](

[DistrictNum] [int] NOT...

I need some one to walk me through this, step by step - Ill show you what I have, you tell me what to do, etc. Apparently I don't know...

Is there a site or article that will lead me in the right direction?

ok, without having to completely scrap my current setup (just reworking my triggers), how can I modify my solution for best performance ?

The tables match, I am not concatenating anything when I insert, and i tried the query with the trigger turned off and it worked fine.

I AM USING SQL SERVER 2005 AND I HAVE THE FOLLOWING TABLE

District

(

row_id int,

DistrictNum int,

Region varchar(50),

D_Addr1 varchar(50),

...