• Keep in mind that the EXECUTE AS clause specifies a database user. I assume that you are a member of sysadmin. In that case, your login maps to dbo in the database.

    For the same reason, it does not work to specify EXECUTE AS 'domain\databaseowner', because there is no such user in the database - or least I would not expect so. The login 'domain\databaseowner' maps to dbo.

    [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]