DATABASE_PRINCIPAL_ID
Returns the ID number of a principal in the current database.
Syntax
DATABASE_PRINCIPAL_ID ( 'principal_name' )
Arguments
'principal_name'
Is an expression of type sysname that represents the principal.
When principal_name is omitted, the ID of the current user is returned. The parentheses are required.
Return types
int
Example
SELECT DATABASE_PRINCIPAL_ID('random_principal_name') ;