Включение CMD в MSSQL
-- To allow advanced options to be changed. EXECUTE sp_configure 'show advanced options', 1; GO -- To update the currently configured value for advanced options. RECONFIGURE; GO -- To enable the feature. EXECUTE sp_configure 'xp_cmdshell', 1; GO -- To update the currently configured value for this feature. RECONFIGURE; GO
CMD в MSSQL: Использовать сетевой диск
EXEC XP_CMDSHELL 'net use H: \\\\RemoteServerName\\ShareName'