Red Gate forums :: View topic - Newbie Problem - Random Extended Properties Change
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Source Control 2
SQL Source Control 2 forum

Newbie Problem - Random Extended Properties Change

Search in SQL Source Control 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
catfood49



Joined: 21 Jun 2011
Posts: 13

PostPosted: Wed Nov 16, 2011 10:51 am    Post subject: Newbie Problem - Random Extended Properties Change Reply with quote

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.
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Fri Nov 18, 2011 1:35 pm    Post subject: Reply with quote

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
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
catfood49



Joined: 21 Jun 2011
Posts: 13

PostPosted: Fri Nov 18, 2011 2:50 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Fri Nov 18, 2011 3:02 pm    Post subject: Reply with quote

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
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
catfood49



Joined: 21 Jun 2011
Posts: 13

PostPosted: Fri Nov 18, 2011 3:53 pm    Post subject: Reply with quote

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 Very Happy
Back to top
View user's profile Send private message
catfood49



Joined: 21 Jun 2011
Posts: 13

PostPosted: Wed Nov 23, 2011 3:51 pm    Post subject: Reply with quote

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:

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
Back to top
View user's profile Send private message
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Thu Nov 24, 2011 5:27 pm    Post subject: Reply with quote

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
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
dykesa



Joined: 19 Jan 2012
Posts: 11
Location: Indianapolis, IN

PostPosted: Thu Jan 19, 2012 3:36 pm    Post subject: Resolution Reply with quote

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

Alan
Back to top
View user's profile Send private message
catfood49



Joined: 21 Jun 2011
Posts: 13

PostPosted: Thu Jan 19, 2012 3:47 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
dykesa



Joined: 19 Jan 2012
Posts: 11
Location: Indianapolis, IN

PostPosted: Thu Jan 19, 2012 4:03 pm    Post subject: It's working now for us Reply with quote

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
Back to top
View user's profile Send private message
catfood49



Joined: 21 Jun 2011
Posts: 13

PostPosted: Thu Jan 19, 2012 4:23 pm    Post subject: Reply with quote

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

Thanks for letting me know.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group