Options
Linked Servers and SQL 7
paulus_999
Posts: 13
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.
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.
Comments
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?
Redgate Software