Its completely in house, it generates a script to re-create the object from the Dev DB. The script then gets attached to the SCR it was checked in on...

Thanks for the replies.

We have decided to setup the following structure for our DBAs:

Global DBA Group – sysadmin on all our SQL servers at all the sites.

VERY selective...

Just had a quick look for you and a likely cause could be that the SQL Server service account doesnt have the required registry permissions. Has the Service account...

Great, thank you for the replies.

Michael - Correct, I needed the associated users from the rows rather than min and max users, sorry if I wasnt clear on...

Thank you for the replies.

OK so let it run unless there is a reason to re-initialise. Thank you.

And I can take a full backup at any time and it...

OK, that makes sense. Thanks for clarifying.

David

Thank you for the reply.

I got that from in here:

http://msdn.microsoft.com/en-us/library/cc671628.aspx

David

Thank you all for your responses, they were very useful to us. We think we have a way to accomplish what we need using Access, with linked tables.

...

I am trying to follow this and am getting an error regarding my connection string. I have set the environment variable and set the package configuration to use it...

All fixed now. Replaced the batteries on the 2 controllers, which re-enabled the write cache.

Thanks

Dave

Just had a call from our I.T dept, the problem is due to the write cache being disabled on the SAN due to it thinking that the batteries have expired....

Yes it is clustered and yes it has been restarted. Thanks.