Microsoft KB Archive/180359

= BUG: sp_addsubscription Fails with Error Number 14096 When Subscribing =

Article ID: 180359

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q180359



BUG #: WINDOWS NT :17776 (6.5)



SYMPTOMS
The replication stored procedure, sp_addsubscription, can fail with the following error when creating a subscription for a valid article:

Msg 14096, Level 16, State 1

The path and name of the table creation script must be specified

if the pre-creation command is DROP.



CAUSE
This problem occurs when multiple articles are created with the same name and one of the articles is manually configured incorrectly. Specifically, an article that is invalid because it is configured with a pre-creation_cmd "1" (DROP Table First), but does not include a creation script, will cause the problem. The sp_addsubscription stored procedure will fail for all articles that share the same name with the invalid article.



WORKAROUND
To avoid the problem, ensure that all articles using the pre-creation_cmd "1" (DROP Table First) include the creation script.



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.

Keywords: kbbug KB180359

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.