windows firewall configured correctly?

corporate firewall configured correctly?

any antivirus disabled from blocking massmail worms and the dbmail executable?

server been granted the right to send mails via SMTP?

authentication issues resolved for logging...

or if you want the keyboard shortcut use CTRL+T

two ways

you will either need to create a new job which has a cmdexec step and pass in the script, then modify the job which is created from the maintenance...

most excellent, this has been book marked and a copy of the zip uploaded to my drop box so I dont forget about it.

why dont you add the script as a step in the job after the backups have completed, that way the sql agent runs the script for you

you could use tools like robocopy, xcopy, SAN replication (if you use a SAN) to copy files between locations which will save you backing up twice

happy to help

Change the DBName in the temp table to a data type of SYSNAME this will then eliminate this error from happening.

what is the largest name of a database on the instance?

on first glance it looks that you have a DB name larger than 25 and its failing inserting into the...

something like this

declare @maxseqid int = 101,@count int, @sum decimal (10,2) = 0, @loop int = 1

select @count = COUNT(*) from seq

while @loop <= @count

begin

select @sum = @sum + amount...

if you have connected over VPN then your acting like your on your companies LAN so there is no issue with connecting to SSRS using your normal windows accounts

but when...

as Database mail uses SMTP the default is port 25, but your exchange admins can change it so you are best speaking to them

can you post the DDL statements for all objects involved, tables procedures triggers etc

would seem like you need to use ranking functions http://msdn.microsoft.com/en-us/library/ms189798.aspx

The SSMS tool kit will do that for you, it assigns each server its own colour so will take some configuring to set the colours of each server.