Avatar of Mauro Cazabonnet
Mauro Cazabonnet
Flag for United States of America

asked on 

SQL Dump exec output to table

What's the best way to dump an exec output to a temp table

USE [Dashboard]
DECLARE @ComputerADpath nvarchar(64) = 'LDAP://DC=demo,DC=lab';
DECLARE @ComputerADfilter nvarchar(64) = '(&(objectCategory=*)(objectClass=computer))';
DECLARE @ComputerMembers XML;
INSERT INTO [dbo].[Computers]
EXEC clr_GetADobjects @ComputerADpath, @ComputerADfilter, @ComputerMembers OUTPUT;

Open in new window

Microsoft SQL Server

Avatar of undefined
Last Comment
Mauro Cazabonnet

8/22/2022 - Mon