Hi,

Put both servers in the same domain which fixed the problem.

Thanks

Dave

Neglected to see that I've also tried this with the firewall off

That's interesting. I've checked with the MS website and it does claim that the limit for tables in transactional is 1000. We did however get an error when...