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.

  • March 31, 2008 at 5:43 am

    #795861

    Could this be a permission problem ?

    For INSERT INTO you only need datawriter permissions, while for a SELECT INTO you need at least CREATE TABLE permissions.

    [font="Verdana"]Markus Bohse[/font]