Hi Graeme,

Yes, we have changed things but we do occassionally add or drop columns as appropriate using the sp_repladdcolumn. As mentioned, I have completely rebuilt (about 5-6 times) and...

Hi Graeme,

What I meant to say was there are 3 databases in total. Each one called UK, US or HK.

Server "SQL-UK1" has 3 databases

UK (published from here)

US

HK

Server "SQL-UK2"...

Hi,

Unfortunately, no one seems to have an answer for this issue, so I am really struggling to get this back up and running without manually configuring all our servers. ...

We have made the user local admin - that seemed to be missing - this appears at first glance to have worked (on one of the two servers affected) we...

Hi Chandra - will try Phillip's suggestion first as it can be done passively (this is a live box) I will then try this if that does not solve...

Hi Phillip,

I think I have checked most of these - I will go through these with a fine tooth comb to ensure they are all OK and come back to...

Hi Anil,

Thanks for the response. We are looking to run under a locked down account and hence are using the domain account that has been created not the admin...