BUG: The vacuuming process stops running when you configure the generator to run on a different computer in SQL Server 2000 Notification Services (914191)


The information in this article applies to:

  • Microsoft SQL Server 2000 Notification Services
BUG #: 406573 (SQLBUDT)

SYMPTOMS

Consider the following scenario:
  • An existing instance of Microsoft SQL Server 2000 Notification Services is running.
  • You configure the generator to run on a different computer.
  • You use the NSControl Update command to update the instance database and the application database.
In this scenario, the vacuuming process stops running.

CAUSE

This problem occurs because the NSControl Update command does not update the SystemName column in the NSVacuumState table when the SystemName column in the NSGenerators table is updated.

WORKAROUND

To work around this problem, follow these steps after you use the NSControl Update command to update the instance database and the application database:
  1. Open SQL Query Analyzer, and connect to the instance of SQL Server 2000.
  2. Run the following code in the query editor. 
    USE <DatabaseName>
UPDATE NSVacuumState
SET NSVacuumState.SystemName = NSGenerators.SystemName
FROM NSGenerators
    Note <DatabaseName> is a placeholder for the name of the application database.

    You must run this code for each application database that belongs to the instance of Notification Services.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

MORE INFORMATION

In Notification Services, the vacuuming process removes obsolete event and notification data from the application database. If the vacuuming process stops running, the size of the application database keeps increasing.

REFERENCES

For more information about the NSControl Update command, visit the following Microsoft Developer Network (MSDN) Web site:

http://msdn2.microsoft.com/en-us/library/ms162829.aspx

To obtain Notification Services Standard Edition 2.0 Service Pack 1 (SP1), visit the following Microsoft Download Center Web site:

http://www.microsoft.com/downloads/details.aspx?familyid=AE73472B-5D7C-4266-94D4-7DDE7E315B98&displaylang=en

To obtain Notification Services Enterprise Edition 2.0 Service Pack 1 (SP1), visit the following Microsoft Download Center Web site:

http://www.microsoft.com/downloads/details.aspx?familyid=79B34DA2-185F-455C-9365-96FFBC6DA608&displaylang=en

You must install Microsoft SQLXML 3.0 Service Pack 3 (SP3) before you install Notification Services. To obtain SQLXML 3.0 SP3, visit the following Microsoft Download Center Web site:

http://www.microsoft.com/downloads/details.aspx?familyid=51D4A154-8E23-47D2-A033-764259CFB53B&displaylang=en

For more information about how to download Microsoft support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How to obtain Microsoft support files from online services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help prevent any unauthorized changes to the file.
Modification Type:MajorLast Reviewed:3/7/2006
Keywords:kbBug kbsql2005ns kbExpertiseAdvanced kbtshoot KB914191 kbAudDeveloper kbAudITPRO
©2004 Microsoft Corporation. All rights reserved.