Its going to take forever! There are like 25 tables in place just for me to update this 1 tables data!

Oh well.

Resolved this. Our developers were using a DSN set to US English! Time wasters!

This is a test I am setting up. The real solution is that Server B is generally distributed via Replication to 5 other servers within out organisation. This data remains...

Ok thats fair enough. How does this sound as a plan? (I am testing it and do get some glitches)...

1) Log ships every hour between Servers A and B.

2) Once...

Well I got Issue 2 to work (started from scratch).

Issue 1 though - Doh! Looks like we will be BCP'ing as we are not in a position to reinstall the...

Cheers.

It was strange as obviously the users restored with the databases, and I scripted in the Logins, and when I ran a comparison query to see if the Users were...

I did (at the time) and it didn't help. In the end I began the entire setup from scratch and it kept failing on the ADMIN share issue. I even...