C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

Use this query to implement SqlcacheDependency

Posted Date: 19 Sep 2008 Resource Type: Code Snippets Category: SQL

Posted By: Shivashankar Chincholi Member Level: Gold
Rating:

Points: 10


alter database  SET ENABLE_BROKER
GRANT SUBSCRIBE QUERY NOTIFICATIONS TO    ex:abc
GRANT CREATE PROCEDURE TO 
GRANT CREATE QUEUE TO 
GRANT CREATE SERVICE TO 
GRANT SUBSCRIBE QUERY NOTIFICATIONS TO 
GRANT SELECT ON OBJECT::schema.(ex:Comp11) TO 
GRANT RECEIVE ON QueryNotificationErrorsQueue TO 
exec sp_helprotect NULL, ''

The following query is to test wether the enable_broker has been set on the database or not..
select is_broker_enabled from sys.databases where name = ''

Note: Different users can be accesing database .. but we can use only one user at a time

to grantpermission for ENABLE_BROKER

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

For Implementing SqlcacheDependency we need to run this queries in the database .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Query to fetch last 2 rows from the table
	Previous Resource: How to use Oracle PLSQL Connect By
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

doors in nj