Thanks for all your replies.

I think I'll go down the Global Groups option if there is no advantage to security by adding local groups.

I can't seem to get a difinitive answer to the question of Local System or Domain Account for the Services.  I've had a look on the microsoft web site and...

Thanks again for you reply Ian.

I will need to use a domain account as the report that is failing needs to write to the Network. 

I could leave the service...

I am looking to use a DBA Domain account to run the SQLSERVER.  This account has access to the report paths and I believe is a local admin on the...

Don't know why the Agent/Service is running under a local system account.

The SQL backups are currently done using Backup exec so I guess thats why it has been set up...

Thanks for the reply.

I am aware of the autogrowth setting.

I just wasn't sure whether or not I would need to stop and start SQL Server Service.

I will make sure...

From speaking to one of the guys here, he tells me it is a port of an old access app.

thanks for your help.

Carl

I'm new to the company and have found that a lot of the tables in the Data Warehouse are set for VARCHAR(255).  As the max row size in SQL is...