Newbie Problem - Random Extended Properties Change

• 
  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

  peter.peart November 18, 2011 07:35

  - 0 +
• 
  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.

  catfood49 November 18, 2011 08:50

  - 0 +
• 
  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

  peter.peart November 18, 2011 09:02

  - 0 +
• 
  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 November 18, 2011 09:53

  - 0 +
• 
  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

  catfood49 November 23, 2011 09:51

  - 0 +
• 
  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!

  peter.peart November 24, 2011 11:27

  - 0 +
• 
  Was there ever any resolution to this? I have recently run across this same issue. Thanks,
  
  Alan

  dykesa January 19, 2012 09:36

  - 0 +
• 
  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

  catfood49 January 19, 2012 09:47

  - 0 +
• 
  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

  dykesa January 19, 2012 10:03

  - 0 +
• 
  Ah, excellent. That could well be our issue too as we had some users on earlier versions too.
  
  Thanks for letting me know.

  catfood49 January 19, 2012 10:23

  - 0 +

Add comment

Please sign in to leave a comment.