Error Message: Execution of user code in the .net Framework is disabled. Enable "clr Enabled" configurartion option.
sp_configure 'clr enabled', 1
GO
RECONFIGURE
GO
GO
RECONFIGURE
GO
The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. Please enable the Service Broker for this database if you wish to use notifications.
--Enable broker for Notification-based Cache
--Notes: must close any connect sessions before runing this
USE master ;
GO
ALTER DATABASE **** SET ENABLE_BROKER;/ Disable_broker
GO
SELECT is_broker_enabled FROM sys.databases WHERE name = '****'
GO
ALTER DATABASE **** SET ENABLE_BROKER;/ Disable_broker
GO
SELECT is_broker_enabled FROM sys.databases WHERE name = '****'
Reference from https://msdn.microsoft.com/zh-cn/subscriptions/securedownloads/ms166035(SQL.90).aspx
如何在数据库中停用 Service Broker 消息传递 (Transact-SQL)
当消息传递处于不活动状态时，消息将保留在传输队列中。若要确定 Service Broker 对于数据库是否处于活动状态，请检查 sys.databases 目录视图的 is_broker_enabled 列。
 安全说明： |
|---|
| 停用 Service Broker 会阻止消息从数据库发送或传递到数据库。但是，这不会阻止消息到达实例。若要阻止消息到达实例，必须删除或停止 Service Broker 端点。 |
SELECT TOP 100 PERCENT seems to prevent SQL Server from spending a lot of time sorting through all the possible query plans.