A duplicate object name has been found.

AdamRinkAdamRink Posts: 13
edited July 2, 2014 7:11AM in SQL Connect
I keep getting this error:
A duplicate object name has been found. This may occur if the SQL Server that you are registering is case sensitive but the case sensitive option is not set.

I cannot figure out which objects these might be? How can I find which objects these are?

Our database collation is Latin_General_Bin . We also have named the same objects in different schemas.
· Share on Twitter

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    I usually recommend opening a command prompt and using DOS the DOS findstr command on the local files on disk.

    Sometimes this happens because you have database folders nested inside database folders. Or "migration scripts", if you are using those.

    Sorry it's not easier to work out why it's broken and how to fix it.
    · Share on Twitter
Sign In or Register to comment.