Search code examples
sqlsql-serverdatabasemaxprefixes

Object name contains more than the maximum prefixes allowed

I have seen a lot of questions about this but I couldn't find the correct answer for me which works.

The object which triggers the problem is like 

test123.de.company.com.Database.dbo.Table

Test123.de.company.com

is the database Server.

Object name contains more than the maximum prefixes allowed

I have tried to write it like this [test123.de.company.com].Database.dbo.Table just like [test123.de.company.com].[Database].[dbo].[Table]

Can you tell me what's wrong with this?

Solution

  • Please try this:

    ["test123.de.company.com"].[Database].[dbo].[Table]

    OP also encountered a new problem after implementing this solution above. OP said:

    Thank you! This worked for me. To be more precise, the join is for a view and if I save/close and then later get back to the design option the quote marks are removed and there is [test123.de.company.com] left over and the error returns. Is there a way to keep them fixed? Otherwise if I change anything I always have to add the quote marks again and again

    Then with the help of DaleK that problem also was solved. DaleK:

    Don't use the design option, script it as alter instead