Home > Troubleshooting > Symptoms and Solutions > Bulk Copy Server Table Error
Under certain conditions, a subscription that uses the Insert Using SQL Server Bulk Copy replication option may fail with the following message:
"Attempt to use Bulk Copy with a non-existent Server table."
This error message normally indicates that the name of the destination SQL Server does not match the name that Windows uses for the destination computer. You can address this problem by matching the SQL Server and computer names, as described below.
Determine the name of the destination computer by opening the Windows computer or system properties.
Determine the name of the destination SQL Server. Use the SQL Server osql utility or the ISQL/w or Query Analyzer tools (sp_helpserver stored procedure) to display the server name.
While connected to the destination SQL Server, run the sp_dropserver stored procedure to remove the old server name. For detailed information about the appropriate arguments for this procedure, see your SQL Server documentation.
Run the sp_addlinkedserver stored procedure to set the SQL Server name to match the Windows Computer Name. See your SQL Server documentation for details.
Stop and restart all SQL Server services. The topic Controlling Services for SQDR, Db2 for LUW, and SQL describes how to stop and restart the SQL Server services.