We are transitioning from SQL Server 2005 to 2008 and suddenly our Execute As User statements aren't working. Did something change between these 2 releases?
A:
Make sure you have synced the login used for that user and the login has the same permissions as in SQL 2005
FlySQL
2010-09-29 14:09:47