?
Solved

insert xp_logininfo results to table

Posted on 2008-06-18
1
Medium Priority
?
1,412 Views
Last Modified: 2008-06-19
I am using this query

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

How can I insert this into a temp table?
0
Comment
Question by:JonMny
1 Comment
 
LVL 4

Accepted Solution

by:
zx10r earned 2000 total points
ID: 21814101
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have a large data set and a SSIS package. How can I load this file in multi threading?
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…
Suggested Courses

616 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question