Microsoft KB Archive/131910

{|
 * width="100%"|

BUG: Scheduled Table Refresh May Fail Using Truncate Option

 * }

Q131910

-

The information in this article applies to:


 * Microsoft SQL Server version 6.0

-

SYMPTOMS
A scheduled table refresh that uses the option to Truncate the table as well as create the index may fail to work because the index already exists on the target table.

WORKAROUND
Do not enable the Index Rebuild option when you choose the Truncate Table option. You can also modify the table creation script so that it does an existence check for the index as it does for the actual table using the EXEC command.

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

MORE INFORMATION
When you enable a scheduled refresh of a table to use the Truncate option, the option to rebuild the index remains even though it really only applies to the Drop Table option for scheduled table refresh. When the Distribution process goes to recreate the index after the table creation, the index already exists, and the Distribution process fails with an ODBC error.

Additional query words: sql6 enterprise manager replication

Keywords : kbprogramming

Issue type :

Technology : kbSQLServSearch kbAudDeveloper kbSQLServ600