Lockup when comparing certain tables

mcsolasmcsolas Posts: 4
edited September 1, 2005 5:16AM in SQL Data Compare Previous Versions
I have the data compare successfully comparing all types of tables in my database. However, when I try and compare certain ones, it just wont work. They are, structurally speaking, very similar. I cannot figure out what is stopping it.

I changed the problematic tables from Non-Clustered indexes to Clustered, then tried again. When I changed that, it stops 'freezing' when starting the comparison. Now it gets to 1% or 3% and stops. The table in question only has 200 rows..

Here is the error I get after waiting for Data Compare to 'unlock' .. takes about 1-2 minutes before this shows up:

SQL Data Compare
A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)


This discussion has been closed.