How to use SqlDependency and to work this properly how to give permissions to Database(sql 2005)

See more:

C#

Hi,

I am using "SqlDependency" concept in my application to build my own query notifiers for my own client application.

Please tell me how to give permission to database to work properly.

I am not able to execute this statements also.

ALTER DATABASE sampleJyothi SET ENABLE_BROKER

GRANT SUBSCRIBE QUERY NOTIFICATIONS TO sampleJyothi

Please give me reply..

Thank You in Advance,
Jyothi S