There is a thread on security related removals in the next version of SQL Server in the MSDN SQL Security Forums and I thought I'd post it here as well to broaden reach.

We are planning on removing group related stored procedures: sp_addgroup, sp_dropgroup, sp_changegroup, sp_helpgroup.

We are also planning on removing aliases and would like some feedback on impact this would have for customers.

Both groups and aliases have been on the deprecated list for some time, so hopefully this isn't painful for anyone. But if it is or there is something we can do to make it easier, let us know - post a reply in the forum thread or here.

Thanks!