select [User Security ID] from [dbo].[User] where [User Name] = 'DOMAIN\USER1' --> example: User Security ID output: 49089BA8-91C5-4BD2-A322-7797760736B2 (User ID by uniqueidentifier) 2) SECOND: ...