The code is a Luis Cazares suggested.

It appears to be finding the correct db now as i get the following but still get an error performing the update

use [DJesus_eCristal]

GO

Msg 102, Level 15, State 1, Line 2

Incorrect...

Yes this is what i am trying to achieve with the lookup searching for the correct hostname and db name

I'm sorry for my ignorance but i'm unsure what you mean with changing EXEC (@SQLCmd) before update

Thanks for that, seemed to get a little further.

I am now having problems with it finding the Application_Settings table which i assume is because it has not found my local...