Newbie Problem - Random Extended Properties Change

A SQL Server Management Studio add-in to source control your database in Subversion or Team Foundation Server.

Moderators: Chris Auckland, David Atkinson, sherr, PhilScrace

Newbie Problem - Random Extended Properties Change

Postby catfood49 » Wed Nov 16, 2011 10:51 am

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.
catfood49
 
Posts: 13
Joined: Tue Jun 21, 2011 11:00 am

Postby peter.peart » Fri Nov 18, 2011 1:35 pm

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
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Postby catfood49 » Fri Nov 18, 2011 2:50 pm

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
 
Posts: 13
Joined: Tue Jun 21, 2011 11:00 am

Postby peter.peart » Fri Nov 18, 2011 3:02 pm

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
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Postby catfood49 » Fri Nov 18, 2011 3:53 pm

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 :D
catfood49
 
Posts: 13
Joined: Tue Jun 21, 2011 11:00 am

Postby catfood49 » Wed Nov 23, 2011 3:51 pm

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
catfood49
 
Posts: 13
Joined: Tue Jun 21, 2011 11:00 am

Postby peter.peart » Thu Nov 24, 2011 5:27 pm

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
peter.peart
Site Admin
 
Posts: 362
Joined: Tue Sep 02, 2008 9:58 am
Location: Top floor, RG towers with the cool kids

Resolution

Postby dykesa » Thu Jan 19, 2012 3:36 pm

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

Alan
dykesa
 
Posts: 11
Joined: Thu Jan 19, 2012 3:24 pm
Location: Indianapolis, IN

Postby catfood49 » Thu Jan 19, 2012 3:47 pm

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
 
Posts: 13
Joined: Tue Jun 21, 2011 11:00 am

It's working now for us

Postby dykesa » Thu Jan 19, 2012 4:03 pm

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
 
Posts: 11
Joined: Thu Jan 19, 2012 3:24 pm
Location: Indianapolis, IN

Postby catfood49 » Thu Jan 19, 2012 4:23 pm

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

Thanks for letting me know.
catfood49
 
Posts: 13
Joined: Tue Jun 21, 2011 11:00 am


Return to SQL Source Control 2

Who is online

Users browsing this forum: No registered users and 0 guests