Enabling SQL CLR

to enable the CLR for any database of SQL 2005
run the following in new query

sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO

Reference:
http://msdn2.microsoft.com/en-us/library/ms254506(VS.80).aspx

SQL2005 caching

1. run SQL statement below on the database
ALTER DATABASE dbName
SET ENABLE_BROKER

2. use one of the following:
On a page:
On a data source control:
on the page get the data that you want and when its updated the page or data source will be updated

3. GRANT SUBSCRIBE QUERY NOTIFICATIONS TO username
4. GRANT SEND ON SERVICE::SqlQueryNotificationService TO username
anyhow there is a lot restrictions on the use of notification that will let you in the end to leave it.