xp_cmdshell 执行多条语句
如何让xp_cmdshell执行多条语句.
set @sqlcmd = 'netsh advfirewall firewall show rule name="SQL Server Browser" >nul'+CHAR(13);
set @sqlcmd = @sqlcmd+' netsh advfirewall firewall add rule name="SQL Server Browser" Action="Allow" Direction="In" Profile="Domain" LocalIP="Any" RemoteIP="Any" Protocol="UDP" LocalPort="1434" RemotePort="Any" Description="set portopening UDP 1434 for SQL Server Browser"';
print @sqlcmd
exec @rc=xp_cmdshell @sqlcmd;
select @rc;
GO
这样不工作!
高手教导下!
谢谢!