SQL compare lists stored procs as changed when are the same

lculley2012

I have used red gate compare 6.0 in the past and am evaluating 10 now. I tried using my downloaded copy to compare two sql 2008 servers but it keeps listing procs as having differences when they do not have differences. I tried setting the options to ignore whitespace but it still shows the differences (I confirmed at SSMS that there are no differences). Tried applying a patch to upgrade to 10.2.0.916 and that did not fix the issue. Any ideas? Very dissapointing--I really have loved sql compare in the past.

peter.peart

Thanks for your post and sorry you're hitting this. Without any screenshots etc. though, I'm not really going to be able to take this any further I'm afraid.

You're more than welcome to either post them up here, or e-mail support@red-gate.com quoting reference F0062254 with further information and we'll be more than happy to look at this further.

Pete