I would suggest to create and run the ssis package for loading the data to another server.If that is the requirement.

I can alter the staging table.

The changes i made after the cdc table enabled.

I have updated a record in customer table and the changes showed up in the customer table and i see 2 records...

Thanks a lot for the reply..I did tried with the mentioned changes and it is updating the grand parent and parent when i tried to modified the parent in other...

Thanks a lot for the solution..

I want to update the parent and immediate child only.(Immediate parent for a child can be determine by chopping of the right most periodplusvalue)

Example:

5.46.200.1.462222.2.1 parent

5.46.200.1.462222.2.1.1...

5.46.200.1.462222.2.1.1.1.1.1.1.2 will be children of parent 5.46.200.1.462222.2.1.1.1.1.1.1

Yes If there's any match of a substring then it would be parent.chop off the right most after period then it would be...

Thanks a lot it works !!

Thanks a lot..

It works..

Does this script reports all failed jobs in one consolidated report for a day in one single email..

The itemstock procedure which create new items found into ITEMMASTER table.

Thanks..I got the results..I want to report the source of users query which in the below results like user/login.

QueryTextSumOfCPUTimeexecution_countAvgCPUTime

Thanks a lot

How to get the login name or user in the query.

Thanks for reply.

I am unable to save connection manager of ssis package in 2005.

When saved it is saving but actual changes was not reflected.

Column.

Here is the sample.

CREATE PARTITION FUNCTION myRangePF1 (int)

AS RANGE LEFT FOR VALUES (1, 2, 3,4,5);

GO

CREATE PARTITION SCHEME myRangePS1

AS PARTITION myRangePF1

TO (test1fg);