CREATE TABLE ServerList_SSIS([Server] NVARCHAR(512),
[Connect] bit,
[DMZ] bit);
INSERT INTO ServerList_SSIS([Server])
EXEC master..xp_cmdshell 'sqlcmd /Lc';
Delete from ServerList_SSIS where [Server] IS NULL;
Select * from ServerList_SSIS
Posts tonen met het label Get sqlcmd output into a table?. Alle posts tonen
Posts tonen met het label Get sqlcmd output into a table?. Alle posts tonen
vrijdag 21 november 2008
Abonneren op:
Posts (Atom)