-- retrieve a list of impersonation rights granted at the server level select spe.* ,spr1.name AS ImpersonatingLogin ,spr2.name AS ImpersonatedLogin from sys.server_permissions spe inner join sys.server_principals spr1 on spe.grantee_principal_id = spr1.principal_id inner join sys.server_principals spr2 on spe.grantor_principal_id = spr2.principal_id where spe.type = 'im' --GRANT IMPERSONATE ON LOGIN::sa to [testlogin]