I am comparing two SQL Server 2000 databases on two different servers, whilst I was comparing I decided to click 'cancel' the program then just hung,

I had to kill it using the task manager,

i'll see if I can replicate it again and get back to you.

Thanks

Al
alaistair
0

Comments

6 comments

  • Bernard Sheppard
    I've seen the same thing happen.
    Bernard Sheppard
    0
  • richardjm
    Can I ask what size of tables you were using to compare - if you click cancel Data Compare will currently continue until reading the current table has finished and then cancel. If you have very large tables this could be the 'hang' effect you're both seeing.

    Also you're both ok for disk space I assume?
    richardjm
    0
  • Bernard Sheppard
    richardjm wrote:
    Can I ask what size of tables you were using to compare - if you click cancel Data Compare will currently continue until reading the current table has finished and then cancel. If you have very large tables this could be the 'hang' effect you're both seeing.

    Also you're both ok for disk space I assume?

    I'm OK for disk space, and the tables are extremely small (< 10k Rows, under 1MB).
    Bernard Sheppard
    0
  • richardjm
    Have you managed to reproduce this problem consistently or does it just seem to be intermittent?
    richardjm
    0
  • alaistair
    disk space is also fine on mine
    alaistair
    0
  • richardjm
    I'll put it into our bugs database as a thing to watch out for and we'll get some internal tests going to see if we can find out what's going on. If you have a database that is particularly prone to it or a cunning way to get the
    problem to show itself that would be wonderful.

    Thanks
    richardjm
    0

Add comment

Please sign in to leave a comment.