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

asked on 

SQL Dump exec output to table

Hi,
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


Thanks,
M
Microsoft SQL Server

Avatar of undefined
Last Comment
Mauro Cazabonnet

8/22/2022 - Mon