BUG: Cannot Load a Table If the Owner Is Not SA or DBO

 Last reviewed: June 5, 1997
Article ID: Q169492
The information in this article applies to:
  • Microsoft SQL Server, version 6.5
BUG #: 16956 (NT: 6.50)

SYMPTOMS

A table cannot be restored from a database or table dump by anyone other than the target table owner if the target table is not owned by the system administrator (SA) or database owner (DBO). This is true even for the SA or DBO of the database; that is, the SA or DBO cannot load a table into a table that a user owns. The LOAD TABLE statement fails with the following error message: 

   Msg 8407, Level 16, State 1
   Invalid target table 'newmy2' specified in LOAD TABLE.
   Table load has been aborted for table 'newmy2'.

WORKAROUND

To work around this problem, do either of the following:

  • If you are the DBO or SA, use the SETUSER statement to impersonate the table owner and then execute the LOAD TABLE statement.

    -or-

  • Create a new table, load the data into this table, and then use INSERT SELECT to copy the data into the target table.

STATUS

Microsoft has confirmed this to be a problem in Microsoft SQL Server version 6.5. We are researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.

MORE INFORMATION

The following are the requirements to load a table. As long as they are satisfied, you should be able to load a table:

  • You must have INSERT permission on the target table.

    -and-

  • The target table's database must have the SELECT INTO/bulkcopy database option set before loading a table.

Keywords : kbbug6.50 kbusage SSrvAdmin SSrvGen
Version : 6.5
Platform : WINDOWS

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: June 5, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.