yes Grant Select on both view and the table

Thanks for all the help. As I said using temp table did resolve the issue

Yes it is bunch of destination table fileds joined to the source table fields but not a denormalized table though. This was working fine until there were only 10 fields...

Thanks.

Checked SQL error and evenlogs can't find any erros

I have set the below on both source and destination server .Hope it works

sp_configure 'remote query timeout', 0

go

reconfigure with override...

Thanks. But using NOLOCK is good?

Is it possible to delete old backups using SQL backup script with RETAINDAYS ?

leave a space between Servername and Varchar and script will run but it will not return any result for SQL 2008 or SQL 2008 R2

ServerName????????????varchar(256),

Try this

ServerName varchar(256)

New code does works for SQL 2005 but it doesn't return any result for SQL 2008 or SQL 2008

R2

Thanks a lot 🙂

can you not change your recovery model from simple to full and try taking log backups?

Because you can't take log backups when recovery model is simple

thanks!

INSERT INTO Databasename2..EMPLOYEE2(EMPID, STARTTIME, ENDTIME, TASK, EVENTID, ADDRESS1)

SELECT a.EMPID, a.STARTTIME, a.ENDTIME, a.TASK, a.EVENTID, a.ADDRESS1

FROM dbo.table1 a LEFT OUTER JOIN Databasename2..EMPLOYEE2 b

ON a.EMPID = b.EMPID

AND a.STARTTIME = b.STARTTIME

AND a.EVENTID = b.EVENTID

AND...

Sorry for the delay I have now attached the query.

Query 1 and query 2 takes approximately two minutes to run but query 3 takes around 9 hours which was running...

Thanks Gail.

But decreasing max memory will have any impact on application users?

Increasing memory will resolve the issue? Am I right in saying that 10-12 % of total memory is enough...

thanks 🙂