Published Wednesday, September 28, 2005 7:19 AM by mtaulty

SQL Changes for RTM

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