Microsoft KB Archive/317832

= PRB: Subscriptions in System Databases Not Supported =

Article ID: 317832

Article Last Modified on 10/16/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q317832



SYMPTOMS
You may see unexpected behavior during a setup or upgrade, as well as during the normal course of operation, when you create subscriptions to SQL Server replication publications in the master database. Microsoft does not support the creation of subscriptions in the master database, or any other system database (such as tempdb, model, or msdb).

For example, if you create a push subscription in the master database, the SQL Server service pack Setup does not upgrade any replication objects in system databases, which results in replication failures and other unexpected behavior.



CAUSE
SQL Server 2000 inadvertently allows you to create subscriptions in system databases. SQL Server should not allow you to create subscriptions in system databases and this configuration may not be possible in future versions of SQL Server.



RESOLUTION
Do not create subscriptions in SQL Server system databases.

Keywords: kbprb KB317832

-

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

© Microsoft Corporation. All rights reserved.