Newbie Problem - Random Extended Properties Change

catfood49

I am using Shared Database Development with Subversion

I have only just started using SQL Source Control and have come across something strange.

I have linked one of my databases to source control and am trying this over 2 PCs. Without making any changes to the database, when I click on Commit Changes, SQL Source Control returns a change to one of my views to do with Extended Properties (a change I have not made). The Changed By value is 'Unknown'.

Why would SQL Srouce Control be reporting on a change I have not made to do with Extended Properties?

Thanks.

peter.peart

Thanks for your post.

In the differences viewer, is there actually a difference in extended properties between what exists in the DB and what exists in SVN?

Pete

catfood49

yes there was but unfortuantely as this was a few days ago i can't remember what that change was, but it definitely wasn't anything I had done. I commited the change and as yet, the same problem hasn't come up again.

peter.peart

Ok, well maybe let us know if it happens again? Sounds odd, but it's going to be really tough to figure out what's happened without knowing the difference etc.

How does that sound?

Pete

catfood49

sounds good to me.

really should have taken a note of the problem in detail but was in bit of a tight deadline. next time

catfood49

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 '

The change between versions is below, with the change highlighted in red:

Database Version
EXEC sp_addextendedproperty N'MS_DiagramPaneCount', 1, 'SCHEMA', N'dbo', 'VIEW', N'VIEW Customers Union', NULL, NULL
GO

Source Control Version
EXEC sp_addextendedproperty N'MS_DiagramPaneCount', NULL, 'SCHEMA', N'dbo', 'VIEW', N'VIEW Customers Union', NULL, NULL
GO

peter.peart

Most odd. Are you able to send me a schema creation script of the DB to support@red-gate.com, quoting reference number F0054440?

Thanks!

dykesa

Was there ever any resolution to this? I have recently run across this same issue. Thanks,

Alan

catfood49

No there wasn't a resolution. With with business of Christmas coming up and a few other source control issues I didn't actually get round to sending a schema script over to Red Gate

dykesa

Thanks for your fast reply. I don't know if this will help you or not but essentially I had one person who was using an older version of SQL Source Control (2.3 maybe?) and as soon as we got him upgraded to 3.0 (like I was using) the problem went away. Hope this helps.

Alan

catfood49

Ah, excellent. That could well be our issue too as we had some users on earlier versions too.

Thanks for letting me know.