This KB article will be released shortly - http://support.microsoft.com/kb/928643
For more Resolution and More information please see the KB article itself. Here is some detail from the article
After you install and configure the Notification Workflow Solution Accelerator for Microsoft Operations Manager (MOM) 2005, notifications are generated as expected. However, when you install the Notification_Workflow_Hotfix.zip file, you experience the following symptoms:
SqlServerError: Source: .Net SqlClient Data Provider Number: 446 State: 9 Class: 16 Server: ServerNameMessage: Cannot resolve collation conflict for like operation. Procedure: NSFire2 Line Number: 35Cannot resolve collation conflict for like operation.
This problem occurs if the collation designation that the NotificationWorkflowNotificationWorkflowApp database and the NotificationWorkflowNSMain database use differs from the default SQL_Latin1_general_CP1_CI_AS collation. If a collation other than the default SQL_Latin1_general_CP1_CI_AS collation is set, the installation of the Notification_Workflow_Hotfix.zip file is not completed successfully.When you perform a custom installation of Microsoft SQL Server 2000, you can select the collation type in the Collation Settings dialog box of the installation program. By default, the SQL Server 2000 installation program uses the following SQL Server collation options for the installation of SQL Server 2000:
After SQL Server 2000 is installed, these settings appear as SQL_Latin1_general_CP1_CI_AS in the SQL Server Enterprise Manager tool. If you click Collation designator in the Collation Settings dialog box when you install SQL Server 2000, the Latin1_General option appears in the Collation designator list. This is by default. After SQL Server 2000 is installed, this setting appears as Latin1_General in the SQL Server Enterprise Manager tool. Note The Latin1_General option may be followed by symbols such as CI or AS. These symbols indicate whether extended options such as case-insensitivity (CI) or accent-sensitivity (AS) have been set.