Home Forums SQL Server 7,2000 General The object name ... contains more than the maximum number of prefixes. The maximum is 2. RE: The object name ... contains more than the maximum number of prefixes. The maximum is 2.

  • One needs to use the square brackets [ ] in this case (one of the few cases when there is no escape).

    So the incorrect syntax SERVER.DOMAIN.DATABASE.SCHEMA.TABLE must become

    [SERVER].[DATABASE].[SCHEMA].

    e.g.

    SELECT TOP 1 *

    FROM [MYSERVER.MYDOMAIN.MYCORP.MYCOMPANY.COM].[MYDATABASE].[dbo].[MYTABLE] ;