PRB: Subscriptions in System Databases Not Supported (317832)


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 7.0
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.
Modification Type:MajorLast Reviewed:10/16/2003
Keywords:kbprb KB317832
©2003 Microsoft Corporation. All rights reserved.