超全1433的SQL语句修复
无需登录分离器,利用SQL命令直接恢复xp_cmdshell
恢复命令:
dbcc addextendedproc ("sp_oacreate","odsole70.dll")
dbcc addextendedproc ("xp_cmdshell","xplog70.dll")
未能找到存储过程'master..xpcmdshell'之解决方法,恢复命令:
EXEC sp_addextendedproc xp_cmdshell,@dllname ='xplog70.dll'declare @o int
sp_addextendedproc 'xp_cmdshell', 'xpsql70.dll'
恢复odsole70.dll:
exec sp_addextendedproc sp_OAMethod,'odsole70.dll'
exec sp_addextendedproc sp_OACreate,'odsole70.dll'
如果报“SQL Server 阻止了对组件 'xp_cmdshell' 的 过程'sys.xp_cmdshell' 的访问
解决方法:执行下面的语句
-- To allow advanced options to be changed. EXEC sp_