Viewing 2 posts - 1 through 2 (of 2 total)
The xp_logininfo reports the Domain groups (or other valid SQL login) how the user is being granted access.
https://msdn.microsoft.com/en-us/library/ms190369.aspx
EXEC xp_logininfo 'BUILTIN\Administrators';
EXEC xp_logininfo 'Contoso\JSmith'
Result:
account nametypeprivilegemapped login namepermission path
Contoso\JSmithuseradmin ...
July 24, 2015 at 11:27 am
#1814856
There is an evaluation "version" for each SQL Version (e.i. Developer, Standard, Entrprise, etc.)
And depends on the core version you can see at the link below, how many processor are...
December 7, 2007 at 11:48 am
#758196