Have a look at the Remote Query Timeout option. You set this with sp_configure.

I think it would be better if you consolidate all the data you need from all 30 SQL Servers to 1 central Database. This would be much better for perfromance...

Sergiy,

Thats the same code I tried in my first post but it doesn't work.

Thanks guys. The DATEADD Function seemd to fix it up.

Thanks.

Ok. Ian Yates, i did try removing the dashes but the same problem occurs.

The problem is that the temp table has 14692 records. When I perfrom the update only 14100...

Sounds like you or someone has attempted to DROP a Publication or a Database that was Published in an unorthodox fashion.

I have seen this before and the way to sort...

This also depends on how big (Rows) the tables are as well. If the tables are small then it wouldn't be much of a hit however, if the tables have millions...

It sure will.

You can either create a DTS Package or create a SQL Job to do all this.

No new trick! You have to use xp_cmdshell.

I have perfromed this many times. However, I restrict this process to the DBA's not the end users.

Unfortunately you can't use ALTER TABLE ALTER COLUMN to change IDENTITY Column Properties using T-SQL.

You will have to do it via EM.

In SQL Server there are a couple of choices however, if you wish to do it via T-SQL then you will have to use BCP.

Have a look in BOL for...

Why can you NOT automate Backup & Restore via a DTS Package or a JOB?

Thats because Error Number 547 is a generic 'Foreign Key violation' type error. One suggestion would be to display to the user something like 'Unable to save/modify data due to...

Phil,

I tried what you said and it worked.

Morty,

How do I check that "Report Caching" is NOT enabled for the Report?

Ok. I did that and that worked. Now when I try to access the report manager i get the following error;

Access to the path "C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportManager\bin" is...