Options

"An item with the same key has already been added" and tSQLt

Curious_TyCurious_Ty Posts: 5
Hi, I have been getting "An item with the same key has already been added." when I am trying to link the database for the first time. I think it has to do with the tSQLt scripts that I have in the files. I have 20 something procedures named SetUp with only the schema differentiating them. Is there any work around to this.

Comments

  • Options
    Anu DAnu D Posts: 876 Silver 3
    Thanks for your email.

    Can you submit the custom error report and make sure you enter your email address when you do this?

    Please let us know when you submit the report and also let us know the email address you used so that I can spot the report.
    Anuradha Deshpande
    Product Support
    Redgate Software Ltd.
    E-mail: support@red-gate.com
  • Options
    CraigEddyCraigEddy Posts: 36 Bronze 3
    We have many, many repeated table names arranged into different schemas. Each of these tables has an audit trigger named

    <schema>.Log<table>

    These are all producing

    "A duplicate definition was found for [].[Log<table>]."

    Note that the schema name is indeed an empty string in the error message, and I suspect that's the bug. :)

    I have submitted the error through the application.

    Version 3.7.2.201
Sign In or Register to comment.