Just thought I should add some additional points about the Visual J# redistributable that's needed to run SQL Dependency Tracker. As part of its installation process SQL Dependency Tracker should download and install this library for you, that is assuming it's not already on your system. However, sometimes this doesn't seem to work out quite the way it should, so if you are having problems you might find the following helpful.
SQL Dependency Tracker will run with either .NET 1.1 or 2.0. If you have both of these framework versions installed SQL Dependency Tracker will run under 1.1.
Now, you need to install the Visual J# redistributable that matches your .NET framework version. You can find all versions of this library at:
http://msdn.microsoft.com/vjsharp/downl ... fault.aspx
However, if you have both .NET 1.1 and 2.0 installed you should download and install the version for .NET 1.1 otherwise SQL Dependency Tracker will not work since it will run under the 1.1 framework in this instance. Otherwise, if you only have .NET 1.1 installed download the 1.1 J# redistributable, and for 2.0 download the 2.0 version.
We have seen one instance in which a customer had the 1.0 version of the J# redistributable installed and SQL Dependency Tracker attempted to use this at runtime, which obviously didn't work out too well. We're not sure how or why this happened, but it's possible that the version of the 1.0 redistributable was incorrectly recognised as the required version during the installation process. If this also happens to you then you should ensure that you have either .NET 1.1 or 2.0 installed, and then follow the instructions in the previous paragraph and install the matching Visual J# Redistributable.
Hopefully this should clear up a few problems that some of you have been having.