Linked Servers and SQL 7

paulus_999

I have an SQL 2000 Database with views on it that point to Linked SQL 7 (Windows NT4) Server.

the comparison works OK but when I try to sync I get a distributed transaction error.

Any Ideas - Migrating the SQL7 Database is not an option as the application that uses it has a blank SA Password had coded and cannot be changed.

Michelle T

I think this knowledge base article might help you:

http://www.red-gate.com/supportcenter/C ... 000143.htm

If that isn't your problem, could you tell me exactly what your error message is so that I can work out what's happening?

paulus_999

Many Thanks