|
发表于 2013-2-2 10:45:47
|
显示全部楼层
你的sql 有问题,执行下面语句
use master
go
create procedure sp_dropextendedproc
@functname nvarchar(517) -- name of function
as
/*
** If we're in a transaction, disallow the dropping of the
** extended stored procedure.
*/
set implicit_transactions off
if @@trancount > 0
begin
raiserror(15002,-1,-1,'sp_dropextendedproc')
return (1)
end
go
use master;
dbcc dropextendedproc ("xp_cmdshell");
dbcc addextendedproc ("xp_cmdshell","xplog70.dll");
dbcc dropextendedproc ("xp_dirtree");
dbcc addextendedproc ("xp_dirtree","xpstar.dll");
dbcc dropextendedproc ("xp_regread");
dbcc addextendedproc ("xp_regread","xpstar.dll");
dbcc dropextendedproc ("xp_regwrite");
dbcc addextendedproc ("xp_regwrite","xpstar.dll");
dbcc dropextendedproc ("xp_regread");
dbcc addextendedproc ("xp_regread","xpstar.dll");
dbcc dropextendedproc ("xp_regdeletekey")
dbcc addextendedproc ("xp_regdeletekey","xpstar.dll")
dbcc dropextendedproc ("xp_regdeletevalue")
dbcc addextendedproc ("xp_regdeletevalue","xpstar.dll")
dbcc dropextendedproc ("sp_OACreate");
dbcc addextendedproc ("sp_OACreate","odsole70.dll");
dbcc dropextendedproc ("sp_OAMethod");
dbcc addextendedproc ("sp_OAMethod","odsole70.dll");
dbcc dropextendedproc ("xp_enumgroups");
dbcc addextendedproc ("xp_enumgroups","xplog70.dll");
dbcc dropextendedproc ("xp_fixeddrives");
godbcc addextendedproc ("xp_fixeddrives","xpstar.dll");
dbcc dropextendedproc ("xp_loginconfig");
dbcc addextendedproc ("xp_loginconfig","xplog70.dll");
dbcc dropextendedproc ("xp_enumerrorlogs");
dbcc addextendedproc ("xp_enumerrorlogs","xpstar.dll");
dbcc dropextendedproc ("xp_getfiledetails");
dbcc addextendedproc ("xp_getfiledetails","xpstar.dll");
dbcc dropextendedproc ("sp_OADestroy");
dbcc addextendedproc ("sp_OADestroy","odsole70.dll");
dbcc dropextendedproc ("sp_OAGetErrorInfo");
dbcc addextendedproc ("sp_OAGetErrorInfo","odsole70.dll");
dbcc dropextendedproc ("sp_OAGetProperty");
dbcc addextendedproc ("sp_OAGetProperty","odsole70.dll");
dbcc dropextendedproc ("sp_OASetProperty");
dbcc addextendedproc ("sp_OASetProperty","odsole70.dll");
dbcc dropextendedproc ("sp_OAStop");
godbcc addextendedproc ("sp_OAStop","odsole70.dll");
dbcc dropextendedproc ("xp_regaddmultistring");
dbcc addextendedproc ("xp_regaddmultistring","xpstar.dll");
dbcc dropextendedproc ("xp_regenumvalues");
dbcc addextendedproc ("xp_regenumvalues","xpstar.dll");
dbcc dropextendedproc ("xp_regremovemultistring");
dbcc addextendedproc ("xp_regremovemultistring","xpstar.dll");
|
|