http://blogs.technet.com/b/andrew/archive/2007/08/02/what-s-missing-from-sql-server-2008.aspxI have just arrived on Eileen Brown's team as the Data IT Pro evangelist. During my extensive interview process I was asked by Keith Burns about the common language runtime (CLR) in SQL server 2005 and I replied with a quotation from his blog "that ifen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.technet.com/b/andrew/archive/2007/08/02/what-s-missing-from-sql-server-2008.aspx#3147120Tue, 04 Nov 2008 14:28:38 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3147120Andrew.Fryer<p>You need to start using roles instead. There are fixed roles created as part of the database. &nbsp;You can add your own and then assign users to them as well as NT groups.</p> <div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3147120" width="1" height="1">http://blogs.technet.com/b/andrew/archive/2007/08/02/what-s-missing-from-sql-server-2008.aspx#3146318Mon, 03 Nov 2008 13:27:59 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3146318Nils B. Sjoeberg<p>I have just started looking at upgrading to SQL 2008, and found that at least one necesseary statement (sp_addgroup) that is used in a fundamental (for my business) db-script is gone in 2008. Do you have any suggestions on work-arounds to make deprecated features from 2005 work in 2008, other than re-writing the scripts, obviously?</p><div style="clear:both;"></div><img src="http://blogs.technet.com/aggbug.aspx?PostID=3146318" width="1" height="1">http://blogs.technet.com/b/andrew/archive/2007/08/02/what-s-missing-from-sql-server-2008.aspx#3061514Tue, 27 May 2008 10:57:43 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3061514Andrew Fryer's Blog<p>My first ever post was about the features in SQL Server 2000 that were deprecated in SQL Server 2005</p> <img src="http://blogs.technet.com/aggbug.aspx?PostID=3061514" width="1" height="1">http://blogs.technet.com/b/andrew/archive/2007/08/02/what-s-missing-from-sql-server-2008.aspx#3032165Tue, 08 Apr 2008 10:07:01 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:3032165Andrew Fryer's Blog<p>My first ever blog post was about the features of SQL Server 2000 that won’t work in SQL Server 2008,</p> <img src="http://blogs.technet.com/aggbug.aspx?PostID=3032165" width="1" height="1">http://blogs.technet.com/b/andrew/archive/2007/08/02/what-s-missing-from-sql-server-2008.aspx#1692802Fri, 03 Aug 2007 16:59:50 GMTd5e57398-b9ef-4490-9955-07cbb4e4a80d:1692802Eileen Brown's WebLog<p>Well our new Data Evangelist has finally started blogging. Andrew Fryer will be looking after all things</p> <img src="http://blogs.technet.com/aggbug.aspx?PostID=1692802" width="1" height="1">