sure but now i came to my room. I will post it tomorrow, code is in office

Regards

Guru

Hi Sean Lange,

I had alter this sp's. When we added or remove columns in master tables it will automatically

altered in archive / history tables and also alter the triggers...

Hi Cadavre

Thanks

Regards

Guru

Thank you

anthony.green

Regards

Guru

declare @STR as nvarchar(max),@SourceSchema nvarchar(50),@SourceName nvarchar(50)

select @SourceSchema=RTRIM(LTRIM(SUBSTRING('Alter table dbo.TableA add test int',1,CHARINDEX('.','Alter table dbo.TableA add test int',0)-1)))

Select @SourceSchema=element from splitarray(@SourceSchema,'table ')

Print @SourceSchema

select @SourceName=...

Thank you MysteryJimbo

Regards

Guru

Thank you MysteryJimbo,

So its better to use Sp's for inserting into audit tables.

Regards

Guru

Hi Andy,

Every transaction table have trigger. And it will affect only one table (for audit purpose)

Create TRIGGER [dbo].[tra]

ON [dbo].[a]

FOR INSERT, UPDATE, DELETE

AS

BEGIN

SET NOCOUNT ON;

DECLARE @inserted int = (SELECT COUNT(1) FROM...

Hi,Sean Lange

I gone through that Sp's. I had made some alteration in the Sp "sp_StandardCDC_enable_table". And its working fine. But Need some more alteration in that SP. If we add...

Hi Eugene Elutin ,Sean Lange

I got one link that enables CDC in Standard edition. I need to try that too.

http://standardeditioncdc.codeplex.com/

Regards

Guru

Yes Sean Lange

Each and every action . Exactly what we get in CDC.

Delete Statement

Insert Statement

...

Hi Sean Lange,

I think i can't use Triggers. Because, The values of Master table will be updated every time a record is inserted / updated / deleted in detail table.....

Thank you Eugene Elutin

Regards

Guru

Hi Sean Lange,

Thank you,

I tried for CDC but its working in enterprise edition only. I'm having standard edition

Regards

Guru

select val.day,SUM(V.data) from val V join val Val on V.day<=val.day group by val.day,val.day

Regards

Guru