BUG: sp_addsubscription Fails with Error Number 14096 When Subscribing (180359)
The information in this article applies to:
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.
| Modification Type: | Major | Last Reviewed: | 10/3/2003 |
|---|
| Keywords: | kbBug KB180359 |
|---|
|