A duplicate object name has been found.

Ingeniously simple database development in Visual Studio

Moderators: David Atkinson, Paul Stephenson, GrahamH, james.allison

A duplicate object name has been found.

Postby AdamRink » Mon Jun 30, 2014 8:34 pm

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.
AdamRink
 
Posts: 6
Joined: Mon Jun 30, 2014 8:29 pm

Postby Brian Donahue » Wed Jul 02, 2014 12:11 pm

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.
Brian Donahue
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Connect

Who is online

Users browsing this forum: No registered users and 0 guests