SA执行命令方法总结

////////////////////////////////////////////////////////////////////////
                              sa执行命令方法总结

                                 By 无敌小黄瓜
////////////////////////////////////////////////////////////////////////

测试环境：windows xp pro sp2 + mssql 2005（服务以system权限启动）

一．xp_cmdshell

EXEC master..xp_cmdshell 'ipconfig'

开启xp_cmdshell:

-- To allow advanced options to be changed.

EXEC sp_configure 'show advanced options', 1

GO

-- To update the currently configured value for advanced options.

RECONFIGURE

GO

-- To enable the feature.

EXEC sp_configure 'xp_cmdshell', 1

GO

-- To update the currently configured value for this feature.

RECONFIGURE

GO

[1] [2] [3] 下一页