Thanks for your help, ALZDBA.  I didn't wait for the parameters to be returned by the executable and assumed it was ploughing straight into the installation!

Cheers.

Thanks John & Ninja... I haven't had time yet to test fully but I have given the developer in question db_ddladmin permission and that's good enough. 

Thanks to you both.

I'll let you know if it works, otherwise it's the db_ddladmin role.

Thanks Ninja,

I was wondering if I could grant the developer the 'create procedure' permission under the properties of the database and permissions page?  Or am i barking up the wrong tree...

I've since found out that if you wish to backup the transaction logs of any database then that database recovery model must be set to Full.

If anyone knows of any...

Cheers Simon,

Hi Simon,

I was just about to post a new thread when I saw your recent post.  Although i'm unable to answer your question I see you have problems which something i'm...

Hi Okafor,

I appreciate where you're coming from.  As a standard SQL server build we tend to split the data onto one mirrored pair and logs/backups onto another mirrored pair.  I...

Thanks guys for all you help... this is exactly what I wanted.  Many Thanks!

As a side issue how did you find out about these 'undocumented' features?

Cheers,

Mark

Of course... how simple!

Thanks Kenneth.

Thanks again to you all.  It is a production server and I was swaying towards setting up individual plans for each database.

Cheers.

Thanks to you both for your advice.

Cheers Greg,

The majority of our servers are sp3a as well... although I suspect this particular server is licensed on the per processor model.  Thanks for the kb article i'll take...

Thanks Greg.

Didn't even think of looking in control panel.  However when I run the select script query analyzer returns a value of 'Disabled'.  Any thought's?

Not important as I can get...

Thanks for the reply Greg.

However i'm actually trying to find out from a previously installed version of SQL Server whether it was installed under a per processor or cal license...