Deploying Crystal Report

Crystal Report's assemlies require separate installation, when you deploy your .Net applucation having crstal report.

Use followinf re-disrtributable package:

For VS 2005
C:\Program Files\Microsoft Visual Studio 8\SDK\v2.0\BootStrapper\Packages\CrystalReports\CRRedist2005_x86.msi

For VS 2008
C:\Program Files\Microsoft SDKs\Windows\v6.0A\BootStrapper\Packages\CrystalReports10_5\CRRedist2008_x86.msi

Troublshooting Service Broker

Recently i was troublshooting a service broker application.
Here are the useful objects
sys.conversation_endpoints Catelog


is_broker_enabled field in sys.databases
Should be enabled

If disabled try following statements
ALTER DATABASE my_database SET SINGLE_USER
ALTER DATABASE my_database SET ENABLE_BROKER
ALTER DATABASE my_database SET MULTI_USER

(It is very strang after a abnormal shutdown of SQL Server, database goes to recovery mode. When it come back the is_broker_enabled was disabled. It took 3 hrs. to identify the problem :(
)