BUG: SEM Allows You to Subscribe Without Specifying DB Name

Last reviewed: May 2, 1997
Article ID: Q142453

The information in this article applies to:
  • Microsoft SQL Server, version 6.0
BUG# NT: 11338 (6.00)

SYMPTOMS

SQL Enterprise Manager allows you to subscribe to a publication without specifying a subscription database. This causes SQL Executive to report the error:

   Attempt to locate entry in sysdatabases for database 'automatic' failed.

WORKAROUND

Ensure that a subscribing database is specified while subscribing to an article or a publication.

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

Under manage subscriptions, while subscribing to an article, even if no database name is given SQL Enterprise Manager allows the user to subscribe. This does not generate any errors and it adds "automatic" as the subscriber_db in the replication tables (such as MSjob_subscriptions, MSsubscriber_jobs, etc).

This causes SQL Executive to generates errors mentioning that "attempt to locate entry in sysdatabases for database 'automatic' failed."


Additional query words: sql6
Keywords : kbbug6.00 kbprg SSrvEntMan SSrvRep
Version : 6.0
Platform : WINDOWS
Issue type : kberrmsg


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 2, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.