I dont know exactly but it compares table records even if I select a row with NULL values so I can say that its not only using the perticular value...

thanks for the prompt reply

Well I am just selecting one column randomly as the comparison key but there is a row in the UI of SQL Data Compare that states...

its just the querry analyzer with this behavious the EM works fine

well as far as i know the no host name was changed

secondly the network guys moved my system to a more secured group in the AD but that should...

OMG i just eneterd the IP address assigned to my system in the drop down list and I find no error

now I am more confused!

yes Jason

As far as i know isqlw windows or the querry analyser makes 2 connections.

1 for the queery part and the other for teh object browser.

so as I am...

The database is running on my local machine.

In run whne i write Isqlw the querry analyser opens and the normal dialog box with a drop down menu to select the...

Hi I am still stuck with this one any body out there might be able to help.

the other nasty thing that is happening with my SQL server is that when...

MSSQLServer service is running