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 of the possible reasons for getting this error is when trying to create a table and the statement is using the 4-part table name instead of just the 3-part name.  If it does, remove the server name as part of the create table statement and just use <DatabaseName>.<Owner>.<TableName>.