Thanks for the Reply.

Is there any way that this can be achieved from SQL Server Management Studio?

Please follow the below steps:

1) SET IDENTITY_INSERT ON

2) insert the values using a INSERT Sql.

3) SET IDENTITY_INSERT OFF

Do remember to turn off the identity_insert to OFF again.

Add as much logging as possible in your job. And also set a ouput file for the job. This can be done in Advanced options of the job. From the...

Please check this

http://social.msdn.microsoft.com/Forums/en/sqlreplication/thread/391ec079-30d8-465d-ab2b-1034ceda3334

Check this... may be helpful to you.

http://www.sqlservercentral.com/Forums/Topic886517-338-1.aspx#bm887407

Try these links

http://blogs.msdn.com/bharry/archive/2009/04/30/tfs-2010-admin-operations-setup-improvements.aspx

http://www.devcurry.com/2010/02/reconfigure-tfs-2010-rc-to-select.html

It would be better if you could post the number of records in the table.

Also i see there is no need for the selecting all id column of all the child tables:

select a.dtimesheetid,b.dtimesheetid,c.dtimesheetid, d.dtimesheetid,e.dtimesheetid,f.dtimesheetid

since a.dtimesheetid = b.dtimesheetid, both are same in the output.

Also, a.dtimesheetid...

The query is correct for joining multiple tables. As you have multiple records in the child tables, the result set eventually will have multiple records.

try putting a DISTINCT in the...

You can use the below code format:

INSERT INTO <Tablename> (Col1, Col2, Col3)

SELECT Col1,Col2, Col3

FROM <table name>

WHERE <Condition>

A long running job can have many causes. A few below:

1) There may be any blocking that caused the job to wait for a resource.

2) If there is any other...

You can backup the production database and restore it in the acceptance environment.

Since you need to do this regularly better to have a restore DB script. This script should take...

Try to compress the table and index which will gain more space and improve performance.

Please check whether the view "rulebook_view" really exists. As you mentioned the schemas are same, then remove the article from the publisher and run the Snapshot Agent manually. After that...

Insert into Non Clustered index column will be more faster as there is no need to change the physical sorting order of the data. Also more indexes on a table...