All the databases i need to run this on are on one server so i dont need to run across multiple servers. But ill certainly keep that in mind if...

Excellent. Thanks very much for the help, thats saved me a whole bunch of time!! 😀

EDIT: Just finished my code, works like a charm, thanks again 🙂

Also im having trouble with the 'GO' in your code... Seems that anywhere i put that errors the script. Removing it enabled the script to run.

Im not entirely sure on the pros and cons of Cursors, but dont i need to "deallocate" it once its finished? or is that implied somewhere in that code? Thanks.

GSquared, thanks for your prompt reply. Yes, the databases i need to run this script on are identical in structure. And they named in a uniform fashion so for the...

Aye i did think of that, to be honest, its not a BIG deal to even have the first letter capitalised. But when i get a bit of time later...

Ok Thanks 🙂 Im lazy so i just used:

UPDATE Contacts

SET LastName = UPPER(LEFT(LastName, 1)) + LOWER(SUBSTRING(LastName, 2, LEN(LastName)))

UPDATE ...

Mostly i was just enquiring about it. No matter what i look into and research, i cant seem to find a suitable answer to my problem. I have thought about...

Excellent. As we speak, we are ordering two new servers - as far as i am aware they are going to be high spec, so i dont see a problem...

Log shipping has been suggested to me, and i had a quick look at Redgate SQL Backup...seems like might be a good solution. Ill need to look further into it...

Im a DB newbie to be honest, been in my job just over a month, but for what its worth, we use Smartphones here, gets the job done. Never had...

Ok i think Log Shipping is the way to go. Had a quick look and it seems likea viable solution for my setup, Redgate SQL Backup looks pretty good so...

Yea this is basically what i thought. I tried to put them off the idea but it seems fixed, which is a pain. And yea, i agree - it would...

Ok cheers everyone. Gonna sit down and think this through, my superior seems to be in a rush about it all but ill be damned if im gonna commit to...

As an update, i looked into Database Mirroring, and it appears people are having problems with scenarios where they have a lot of databases to mirror. Apparently microsoft recommends only...