I've used this http://www.sqlservercentral.com/scripts/Index+Management/30721/ before to log reindexing, I think it works on SQL 2005 as well you'd need to try it.

Thats great news glad you've got it working.

Try adding some logging on the job when it runs to get some more information its a bit difficult without seeing the job you've set up to tell what's happening

There is absolutely no reason why this shouldn't work, have you double checked all the variables and connections?

Thanks

We now have it on 90% of servers with no issues as yet.....

Can you post the command you are running?

Is there any more information in the maintenance plan log, when the job runs.

I had similar happen, to debug I usually go to the maintenance plan and get the script of the job that runs, and run it manually in Management Studio. It...

It could be that a SQL Agent job is being run by the user account still, it may just his windows account has been removed. Check if that user account...

piet_dj

M Chabot is correct here the instructions you download with 7 zip will give you the syntax to password protect the file if this is needed.

I find it useful ...

Shouldn't it also be possible to use native Windows functions to compress and uncompress groups of files into .zip-compatible archives? NOT "compress" like the command line .exe or operating...

I think its up to 4GB, using 7 zip, but you should really check on the 7 zip site http://www.7-zip.org/. If the files you want to zip are bigger than...

To find the service account:-

SET NOCOUNT ON

USE MASTER;

DECLARE @serviceaccount varchar(100),

@agentaccount varchar(100)

--Retrieve the Service account from registry

EXECUTE master.dbo.xp_instance_regread

N'HKEY_LOCAL_MACHINE',

N'SYSTEM\CurrentControlSet\Services\MSSQLSERVER',

N'ObjectName',

@ServiceAccount OUTPUT,

N'no_output'

--Display the Service Account

SELECT @Serviceaccount

--Retrieve the Agent account from registry

EXECUTE master.dbo.xp_instance_regread

N'HKEY_LOCAL_MACHINE',

N'SYSTEM\CurrentControlSet\Services\SQLSERVERAGENT',

N'ObjectName',

@agentaccount OUTPUT,

N'no_output';

SELECT @agentaccount

Can you post the formula you are using at the moment and tell us the rounding you are trying to achieve?

Reporting Services ticks all the boxes for your requirements. It also has some similarities with Access so it shouldn't be too hard to figure out. The interface to email reports...