Mike Taulty's Blog
Bits and Bytes from Microsoft UK
SQL Changes for RTM

Blogs

Mike Taulty's Blog

Syndication

Elsewhere

Follow on Twitter
Follow on Channel 9
Follow on Vimeo
View mike's profile on slideshare
Add to Technorati Favorites

UK Team

Tags

View more

Archives

I was trying to move some of my older demos of SQL 2005 from the June CTP across to the September CTP builds and had some trouble particularly around deploying assemblies that are using EXTERNAL ACCESS and also around sending/receiving with service broker.
 
Both of these turned out to be new permissions that I needed to have - you can grant EXTERNAL ACCESS and I also had trouble in getting my Query Notification demo to work due to what seems like the new grant SUBSCRIBE QUERY NOTIFICATIONS that I hadn't seen.
 
Along similar lines, the SqlDependency class for doing query notifications has changes as it goes towards RTM - you can read the details here: http://blogs.msdn.com/dataaccess/archive/2005/09.aspx
Posted Wed, Sep 28 2005 7:19 AM by mtaulty
(C) Mike Taulty, 2010. All rights reserved. The information in this weblog is provided "AS IS" with no warranties, and confers no rights. This weblog does not represent the thoughts, intentions, plans or strategies of my employer. It is solely my opinion. Inappropriate comments will be deleted at the authors discretion. All code samples are provided "AS IS" without warranty of any kind, either express or implied, including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.
Powered by Community Server (Non-Commercial Edition), by Telligent Systems
bliss:andrewbelon.com