Listening to events, such as create database within SQL Server 2008

Question

Appologies if this has been posted before, however I am struggling with terminology and can't seem to find what I am after.

My aim is hopefully fairly simple, I want to be able to run an external C# windows form application, which listens to events happening within SQL Server 2008. For example I want to know when a row to a specific table is added, or even when a table\database is created.

I have been reading around and come accross service brokers, but I am not 100% what these really do, something to do with message queues? I have downloaded and try to run the Service Broker Hellowolrd_CLR example, but I am presented with the error message "Could not find any service with the name 'HelloWorldClient' in this database." I have run the install script, which ran without errors and I have the database for the example installed, but I am unsure how to resolve the issue.

Are there any books on this that anyone would recommend? Or point me in the direction of a simple and detailed tutorial on how I might acheive this? Whilst I wouldn't class myself a novice using SQL Server, I am by nomeans an expert.

Any help is greatly appreciated.

James