August 2007 Entries

"Cannot drop the queue 'SqlQueryNotificationService-{GUID}', because it does not exist or you do not have permission."

Working on my first SQL 2K5 application here...and came across this error trying to implement the SqlNotificationService. I read a lot on this error...However, I was able to avoid this error by simply making the current user of own the DB. 1. Security > Users > [select the user your application is accessing the DB as] 2. Select properties (right click) 3. Find and check your DB schema in the list of "Owned Schemas" 4. Ensure "DB Owner" is checked off in the "Role Members" list That's it...
Posted On Tuesday, August 21, 2007 10:44 AM | Feedback (0)

SqlSiteMapProvider in VB.NET

UPDATE 6.18.2008: You can download the file from here Alright, so I wanted to build a dynamically/DB driven role-based menu system utilizing framework 2. I started with this article… http://msdn.microsoft.com/m... And then converted to VB.NET…Not to come across some items that I needed to change… I came across the following errors: “'System.Web.Caching.CacheI... is a delegate type and requires a single 'addressof' expression as the only argument to the...
Posted On Tuesday, August 07, 2007 11:10 AM | Feedback (18)

Twitter