Thanks for the quick response, the problem seems more with the report server or with the configuration than with the smtp.

The reason(s) why I say this is that:

Some subscriptions have...

Hi,

Many thanks for the info, extremely useful!! I have however run into a further problem during the upgrade and noticing various message boards you seem like the report server guru!!

The...

Thanks for the response again, clear and concise. Unlike the planning for using timed subscriptions!!! You are correct, the reports that have nulls are timed and the one that has...

Thanks for that. Looks good, however the nextruntime in the schedule table is NULL. could there be any obvious reason for this?

Thanks.

returns no rows I'm afraid

Sounds like the same symptoms. There must be a way to find or trap the problematic code

I am not wanting to shrink the file, that is a completely different task and I have already truncated the log. I am after ideas on trying to track down...

Thanks satchin I appreciate your advice,

I can truncate the log file, which would work, its already been a scheduled job on one of the dbs (every 4 hours) just to...

Thanks for the reply Sachin,

Yes it is just the Log of the TempDB that is growing and it has only just recently started, but it is now grown continuously for...

thanks for the reply, I already have those settings correct

cheers for the help, The machines have been tested without firewall. Also, I have read this in microsoft website:

Before the release of Windows XP and Windows Server 2003, the...

All options in the Transaction Manager Communication section are selected except: Enable TIP Transactions. RPC & RPC Out are both enabled in the linked servers and the MSDTC Service is...

Thanks for the reply,

The settings I have are for the MSDTC are as follows:

Network DTC Access

Allow Remote Clients Allow Remote Admin

Allow Inbound ...

Brilliant, that worked a treat. Has been great over the weekend. Thanks!!!

Thanks for your reply, although the servers arent imaged. They are just normal SQL Servers. I ran a query 3 times this morning, it finally worked on the last execution.