We could but we'd have to do it several times a day.

They use a home-grown version of ODBC to transfer the data (something called "DR Manager").

With replication in place, DR Manager sees replication, panics and shuts down to update...

Hi all

Thanks for all the advice.
We need to move a lot of data on a regular basis (which is why we were looking at replication).

I...

The data on server A changes continuously and we need to have near-real-time reporting from it.
I'm not sure what a materialised view is (never heard of that one) so...

Very true.
Like I said, we wanted to use replication to do the transfers real-time (or near enough real-time).  This would then get us away from going cross-server completely.

We could do that, but we need to move a lot of data across to the new server.
The powers-that-be want near-real-time reporting and we aren't allowed to run too...

Steve - Brilliant, thank you.  That query now runs in under 5 minutes (which is fine for now).  I'd never even considered OPENQUERY to do that bit.

Eric -...

Thanks for that.
Looks like we'll be switching off replication, allowing the vendor to make changes and then reinstating replication.

That will add around 4-5 hours downtime to any...

From what we've been  told by the vendor, we need to stop replication when they make a change or the change will fail (they're using home-grown transfer and change methodologies...

Unfortunately it's not quite that simple.
The vendor might change tables x, y and z this time around but it could be tables a, b and c next time. 

Hi all

I can vaguely remember setting something for last login in date but it does mean 2 things:-
1) You need to switch on logging for successful logins...

Thanks for that.  Looks like I mis-read something then.

I'll request more RAM for the server(s) and do some re-configuring and see if we can get them running any...

Hi Thom

On Server1 there is a total of 16GB.
I've set up SQL to be able to access 12GB of that (leaving 4GB for Windows as I understand...

For me (and please remember it's very early on a Monday morning and I haven't had much coffee yet), the code won't do what the question asks.

You're ignoring...

Hi all

I've solved the issue and the entire SP now runs in 14 seconds (and that includes an insert into our working table).

All I've done is...