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.

  • December 13, 2006 at 2:05 pm

    #677906

    This seriously saved my ass. This is the only way to use an UPDATE with linked servers when you want to update only one column.

    Thank you, thank you, thank you.