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, andy.campbell.smith
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 18.104.22.1682
SQL Server 2012
Microsoft MSXML 3.0 6.0
.NET Framework 4.0.30319.34003
Windows 8.1 Pro (6.3.9600)
- Posts: 2
- Joined: Fri Jan 17, 2014 4:12 pm
I just started getting these same errors as well based on constraints.
- Posts: 13
- Joined: Fri Jun 14, 2013 9:03 pm
Can you drop us an email at email@example.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
- Posts: 173
- Joined: Thu Oct 20, 2011 11:19 am
- Location: Red Gate Software
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.
- Posts: 34
- Joined: Tue May 09, 2006 8:06 pm
Well, here I am on version 22.214.171.124 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?
- Posts: 9
- Joined: Tue Nov 06, 2012 5:39 pm
Return to SQL Source Control 3
Who is online
Users browsing this forum: No registered users and 0 guests