asp.net sql sitemap provider and SQL service brokers


while trying to use sql sitemap provider by Jeff Prosise http://msdn.microsoft.com/msdnmag/issues/06/02/WickedCode/default.aspx I came across few issues, and one of the issue was related to SQL Server service brokers. It turns out that SQL server 2005 ships with a new feature called Service broker, according to which applications can interact with the database in an asynchronous way exchanging information in message queues, I was quite impressed by the feature, and although I have just read about it, it seems to be a very useful one to develop reliable and scalable applications. The .net code that I was trying to use was throwing a message of SQL Service broker not enabled for the database, which after a little investigation I found out can be enabled by just using the command

ALTER DATABASE test SET ENABLE_BROKER;

The details about SQL Service broker can be found at MS site

 http://technet.microsoft.com/en-us/library/ms166104(SQL.90).aspx

Advertisements

2 thoughts on “asp.net sql sitemap provider and SQL service brokers

  1. Hi Imran,
    I read the article of jeff and tried to apply, i followed all instractions and enabled service brokers, realy i think there is a problem of the code, some times when it checks if _root isnot nothing then every time it is true and retuns back, ok if i change the data of the table the sitmap still holds it is old value unlles i made change to the code, the other thing when i checked sql profile every time the program calls the procedure if i change or not, becouse what i was expecting if there is no change of data it was supposed to retain the old value so when i checked the code i can’t see any where used to check if data is changed or not.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s