my problem with extended properties has come up again.
A colleague of mine clicked on the Commit Changes button on one our of databases and was told a difference between the database and source control versions had been found. This once again related to a view that looks at a single table (that has not changed). Whilst I cannot be 1005 certain, it is highly unlikely anyone would have changed this view, esepcially as the view is little more complicated than a 'select * from [table name]'
The change between versions is below, with the change highlighted in red:
EXEC sp_addextendedproperty N'MS_DiagramPaneCount', 1, 'SCHEMA', N'dbo', 'VIEW', N'VIEW Customers Union', NULL, NULL
Source Control Version
EXEC sp_addextendedproperty N'MS_DiagramPaneCount', NULL, 'SCHEMA', N'dbo', 'VIEW', N'VIEW Customers Union', NULL, NULL