Microsoft KB Archive/71076

{| = Save As Fails When Specifying a Different SQL Server Database =
 * width="100%"|

Last reviewed: December 18, 1995

Article ID: Q71076

SUMMARY
Attempting to save a table to a SQL Server database other than the current database will result in the following error message in Q+E version 3.00:

Invalid object name 'database.owner.table_name' The table will be created but will be empty. This feature works correctly in Q+E version 2.50.

Steps to Reproduce Problem

 * 1) Start Q+E and log on to a SQL Server.
 * 2) Open the example file ADDR.DBF from your Q+E subdirectory.
 * 3) From the File menu, choose Open and Select SQLServer as the Source.
 * 4) Select the Master database and then choose Cancel.
 * 5) From the File menu, choose Save As and select SQLServer as the Destination. Verify that the line under the Destination list box reads &quot;Owner is master.owner&quot; where &quot;owner&quot; is the alias that you used when logging on.
 * 6) Enter &quot;pubs.dbo.xyz&quot; (without the quotation marks) in the File Name dialog box.
 * 7) You will get the message &quot;Invalid object name: 'dbo.xyz.'&quot;
 * 8) Choose Cancel and then choose Open from the File menu.
 * 9) Select the table &quot;xyz&quot; from the Pubs database.
 * 10) The table will not contain any records.

Work Around

 * 1) From the File menu, choose Save As.
 * 2) Select the database to which you want to save.
 * 3) Choose Cancel and choose Save As from the File menu.
 * 4) The database you chose will now be the default destination.

Microsoft is researching this problem and will post new information here as it becomes available.
 * }