Sugesh,

   Thanks for the pointer. In looking at this area I think that I will need to create 3 scripts for each Database on the SQL Instance and run them...

Mark,

  Thank you for your response. I will explore this and see what can be achieved.

Colin

I have managed to force it through, but am not happy about the situation. Could be that we need to rebuild the test server. Now there is a nice job...

 This is a single, stand alone server. I recognise the benefits of smtp-mail and I am ttrying to get authorisationn to install it.

How did you solve the problem, before you...

George, We would set up Mirroring on its own and use the secondary server as the stand by. We would NOT set up Log Shipping. My boss has asked the question,...

Thanks all.

I believe that auto switch over in Miirroring is only available with the Enterprise version. It is a manual process with Standard Edition, which we will be using. We...

Adam,

    Many thanks for that. I see that you are setting the fillfactor at 80; as I do not know the existing fillfator I think that I should replace the...

Thanks to all who responded, a great thread of information which has reinforced my own thoughts of 1 Dbase per application. We do indeed run a central Database for names,...

John,

    As it is a non emergency situation I have decided to take the "if it ain't broke don't fix it" apprroach.

    However, it would be good to know...

John,

    Thanks. It looks like these Indexes are best left alone.

Colin

  Thank you so much. Good, clear answer. Looks like being a good day!

Thanks

Colin

  It is the most recent 2 or 3 days of BAK files that show an A. Older files do not. What would account for that?

Thanks

Colin

  Thank you for the ideas, much appreciated.

Thank you

Colin

Thanks folks. I will have to sort this from a different angle. Anyway, it was good to experiment.

Cheers

Colin

Thank you for the prompt reply.

However, if I enter dbo.Generate_Retire_Date(BirthDate) in "Default value" and try and save I get an error message saying "Error validating the default for column (Agreed_Retirement_Date)

The...