insert xp_logininfo results to table

I am using this query

xp_logininfo @acctname = 'ad-ent\msuued', @option = 'all'

How can I insert this into a temp table?
LVL 9
JonMnyAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
zx10rConnect With a Mentor Commented:
CREATE TABLE #temp
(
      [account name] varchar(50),
      [type] varchar(50),
      [privilege] varchar(50),
      [mapped login name] varchar(50),
      [permission path] varchar(50)
)

INSERT #temp
EXEC xp_logininfo @acctname = 'ad-ent\msuued', @option = 'all'
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.