Souce Control error - table trigger is a duplicate object?

Discussion of open issues, suggestions and bugs regarding database management and development tools for SQL Server
Post Reply
jeriv
Posts: 1
Joined: Wed 12 Feb 2020 20:22

Souce Control error - table trigger is a duplicate object?

Post by jeriv » Fri 14 Feb 2020 17:27

Hi,

We're trying out your dbForge Source Control product (demo) but are having problems table triggers. When we do the initial commit of the database, it works properly. However, when we refresh, it determines that the table trigger associated to one of the tables is a new change. But when we try to commit it an error is returned saying it is a duplicate object.

Object '*****_info_ts_trig' of Trigger type located in 'C:\Users\*****\AppData\Roaming\Devart\dbForge Common Settings\Repositories\ilimddvu\Tables\dbo.*****_SCHP_INFO.sql (0, 36)' duplicates object '*****_info_ts_trig' of Trigger type located in 'C:\Users\*****\AppData\Roaming\Devart\dbForge Common Settings\Repositories\ilimddvu\Tables\dbo.*****_SCHP_INFO.sql (0, 12)'

Any thoughts on what the problem might be?

Thank you.

alexa
Devart Team
Posts: 2871
Joined: Fri 24 Jun 2011 14:17

Re: Souce Control error - table trigger is a duplicate object?

Post by alexa » Mon 17 Feb 2020 11:12

Could you please perform the following:
1. Right-click a database in Objects Explorer and select 'Source Control -> Trace -> Start Tracing' from the popup menu.
2. Reproduce the issue.
3. Right-click a database in Objects Explorer and select 'Source Control -> Trace -> Send Trace Log to Devart' from the popup menu. It will send a log file to us for further investigation.

Post Reply