VS2013 Schema Compare Identifies Identical Objects as Different

Question

Post reply

VS2013 Schema Compare Identifies Identical Objects as Different

Phil Parkin

SSC Guru

Points: 246963
More actions
February 17, 2015 at 8:44 am

#297842

This happens to me occasionally, in different databases with different types of object, and I've finally summoned the energy post here to see whether anyone else experiences the same thing.
I have a database which I am comparing with a VS2013 database project.
Running the comparison results in the display of a single proc.
Drilling into the body of the proc, I see that there are no differences identified between db version and project version.
If I shrug my shoulders and 'Update' anyway, after completing the update and doing another Schema Compare, the proc once again is identified as being different.
Anyone else seen this? Any explanations out there?
By the way, I have 'Ignore whitespace' selected.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47174 More actions · Answer 1

Yes, I get the same - it's not very helpful is it?

I hope this prompts someone to point out how to spot the difference...

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);