what do the following DMVs return?
select * from sys.user_token
select * from sys.login_token
use impersonation, so you can copy the result
->
execute as login = 'XYZ'
Andreas
---------------------------------------------------
MVP SQL Server
Microsoft Certified Master SQL Server 2008
Microsoft Certified Solutions Master Data Platform, SQL Server 2012
www.insidesql.org/blogs/andreaswolter
www.andreas-wolter.com