Duplicate Definition Error

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

Red Gate Source Control duplicating CREATE TRIGGER

Postby rick@syncbak » Fri Jan 17, 2014 4:20 pm

I'm experiencing the same problem today. I tried to link and synch source control & got the infamous "A duplicate definition was found for trigger..." error. I went into the existing source control file, found the duplicate, removed it, & checked in. I then committed outstanding changes, & the duplicate reappeared, obviously fabricated by Red Gate Source Control. So I manually removed the dupe again.

Please fix this Red Gate!


SQL Source Control 3.5.4.332
SQL Server 2012
SSMS 11.0.3128.0
MDAC 6.3.9600.16384
Microsoft MSXML 3.0 6.0
.NET Framework 4.0.30319.34003
Windows 8.1 Pro (6.3.9600)
rick@syncbak
 
Posts: 4
Joined: Fri Jan 17, 2014 4:12 pm

Ditto - again today

Postby jsreynolds1 » Thu Mar 06, 2014 3:33 pm

I just started getting these same errors as well based on constraints.
jsreynolds1
 
Posts: 22
Joined: Fri Jun 14, 2013 9:03 pm

Postby andy.campbell.smith » Thu Mar 13, 2014 3:15 pm

Can you drop us an email at support@red-gate.com and quote the ticket number #14507? We'd be interested into looking into this problem in more detail to see if we can sort it out - thanks!
Andy Campbell Smith

Red Gate Technical Support Engineer
andy.campbell.smith
 
Posts: 173
Joined: Thu Oct 20, 2011 11:19 am
Location: Red Gate Software

Postby nhustak » Wed Apr 02, 2014 12:40 pm

Filed a support request - this problem really needs to get fixed. Been going on way too long.

A duplicate definition was found for the trigger [dbo].[trg_users_IDU]. Ensure that case sensitivity options are set correctly and all object creation scripts are valid. If the problem persists, contact our support.
nhustak
 
Posts: 40
Joined: Tue May 09, 2006 8:06 pm

Postby pk_davidson » Tue Aug 19, 2014 8:57 pm

Well, here I am on version 3.7.0.2 and this is still happening to me.

It is now only occurring on my test server and fortunately not on production but still it's so very annoying.

What's even more annoying, I deleted the triggers from the database completely. I suspect (HOPE) this is an error from an old issue that was never cleaned up?

I'm hoping one more dive into workingbases and I never see this again?
pk_davidson
 
Posts: 9
Joined: Tue Nov 06, 2012 5:39 pm

Re: Duplicate Definition Error

Postby freecell1 » Thu Feb 05, 2015 8:58 pm

I just had this issue using SSC 3.7. Someone reordered the columns in a table and also edited the trigger in the same commit. No migration script. After that, no one else could get latest.

As a workaround, just having the other developers unlink and relink the database solved the problem.
freecell1
 
Posts: 25
Joined: Tue Mar 13, 2012 8:21 pm

Re: Duplicate Definition Error

Postby Robert Clenshaw » Mon Feb 09, 2015 1:03 pm

freecell1 wrote:I just had this issue using SSC 3.7. Someone reordered the columns in a table and also edited the trigger in the same commit. No migration script. After that, no one else could get latest.

As a workaround, just having the other developers unlink and relink the database solved the problem.


Unlinking and relinking is usually a good place to start. If that doesn't work for some reason, you can always create a new database locally and do a "get latest" to get back to where you were.
Robert Clenshaw
Product Support Engineer
Red Gate Software Ltd
E-mail: support@red-gate.com
Robert Clenshaw
 
Posts: 98
Joined: Wed Oct 22, 2014 3:07 pm
Location: Redgate Software, Cambridge

Re: Duplicate Definition Error

Postby grh395 » Fri Feb 20, 2015 6:09 pm

Ha Ha - yes, thanks! I will remember the Ctrl+Shift tip now. So neat & simple. :idea: I never realised I could access the working base folder like that. :D
grh395
 
Posts: 1
Joined: Fri Feb 20, 2015 5:50 pm

Previous

Return to SQL Source Control 3

Who is online

Users browsing this forum: Yahoo [Bot] and 0 guests