Delete and restore Extended Stored Procedures SQL 2000 database

Command to delete SQL extensions

Use master
Exec sp_dropextendedproc 'xp _ export shell'
Exec sp_dropextendedproc 'xp _ dirtree'
Exec sp_dropextendedproc 'xp _ enumgroups'
Exec sp_dropextendedproc 'xp _ fixeddrives'
Exec sp_dropextendedproc 'xp _ loginconfig'
Exec sp_dropextendedproc 'xp _ enumerrorlogs'
Exec sp_dropextendedproc 'xp _ getfiledetails'
Exec sp_dropextendedproc 'SP _ oacreate'
Exec sp_dropextendedproc 'SP _ oadestroy'
Exec sp_dropextendedproc 'SP _ oageterrorinfo'
Exec sp_dropextendedproc 'SP _ oagetproperties'
Exec sp_dropextendedproc 'SP _ oamethod'
Exec sp_dropextendedproc 'SP _ oasetproperties'
Exec sp_dropextendedproc 'SP _ oastop'
Exec sp_dropextendedproc 'xp _ regaddmultistring'
Exec sp_dropextendedproc 'xp _ regdeletekey'
Exec sp_dropextendedproc 'xp _ regdelete'
Exec sp_dropextendedproc 'xp _ regenums'
Exec sp_dropextendedproc 'xp _ regread'
Exec sp_dropextendedproc 'xp _ regremovemultistring'
Exec sp_dropextendedproc 'xp _ regwrite'
Drop procedure sp_makewebtask
Go

Restore the extended stored procedure and execute the following statement. As for the storage process sp_makewebtask, you can copy a script from someone else. The stored procedure generated after execution can also be used.

Use master
Exec sp_addextendedproc xp_cmdshell, 'xp _ cmdshell. dll'
Exec sp_addextendedproc xp_dirtree, 'xpstar. dll'
Exec sp_addextendedproc xp_enumgroups, 'xp log70. dll'
Exec sp_addextendedproc xp_fixeddrives, 'xpstar. dll'
Exec sp_addextendedproc xp_loginconfig, 'xplog70. dll'
Exec sp_addextendedproc xp_enumerrorlogs, 'xpstar. dll'
Exec sp_addextendedproc xp_getfiledetails, 'xpstar. dll'
Exec sp_addextendedproc sp_oacreate, 'odsole70. dll'
Exec sp_addextendedproc sp_oadestroy, 'odsole70. dll'
Exec sp_addextendedproc sp_oageterrorinfo, 'odsole70. dll'
Exec sp_addextendedproc sp_oagetproperty, 'odsole70. dll'
Exec sp_addextendedproc sp_oamethod, 'odsole70. dll'
Exec sp_addextendedproc sp_oasetproperty, 'odsole70. dll'
Exec sp_addextendedproc sp_oastop, 'odsole70. dll'
Exec sp_addextendedproc xp_regaddmultistring, 'xpstar. dll'
Exec sp_addextendedproc xp_regdeletekey, 'xpstar. dll'
Exec sp_addextendedproc xp_regdelete, 'xpstar. dll'
Exec sp_addextendedproc xp_regenums, 'xpstar. dll'
Exec sp_addextendedproc xp_regread, 'xpstar. dll'
Exec sp_addextendedproc xp_regremovemultistring, 'xpstar. dll'
Exec sp_addextendedproc xp_regwrite, 'xpstar. dll'

The preceding statements are automatically generated. If you are interested, take a look at the following statements. The preceding statements are generated in this way. Because the Extended Stored Procedure on my machine is not dropped, the above statements can be generated.

Create Table # temp (name varchar (100), DLL varchar (100 ))

Truncate table # temp

Insert into # temp
Exec sp_helpextendedproc 'xp _ Your shell'
Insert into # temp
Exec sp_helpextendedproc 'xp _ dirtree'
Insert into # temp
Exec sp_helpextendedproc 'xp _ enumgroups'
Insert into # temp
Exec sp_helpextendedproc 'xp _ fixeddrives'
Insert into # temp
Exec sp_helpextendedproc 'xp _ loginconfig'
Insert into # temp
Exec sp_helpextendedproc 'xp _ enumerrorlogs'
Insert into # temp
Exec sp_helpextendedproc 'xp _ getfiledetails'
Insert into # temp
Exec sp_helpextendedproc 'SP _ oacreate'
Insert into # temp
Exec sp_helpextendedproc 'SP _ oadestroy'
Insert into # temp
Exec sp_helpextendedproc 'SP _ oageterrorinfo'
Insert into # temp
Exec sp_helpextendedproc 'SP _ oagetproperties'
Insert into # temp
Exec sp_helpextendedproc 'SP _ oamethod'
Insert into # temp
Exec sp_helpextendedproc 'SP _ oasetproperties'
Insert into # temp
Exec sp_helpextendedproc 'SP _ oastop'
Insert into # temp
Exec sp_helpextendedproc 'xp _ regaddmultistring'
Insert into # temp
Exec sp_helpextendedproc 'xp _ regdeletekey'
Insert into # temp
Exec sp_helpextendedproc 'xp _ regdelete'
Insert into # temp
Exec sp_helpextendedproc 'xp _ regenums'
Insert into # temp
Exec sp_helpextendedproc 'xp _ regread'
Insert into # temp
Exec sp_helpextendedproc 'xp _ regremovemultistring'
Insert into # temp
Exec sp_helpextendedproc 'xp _ regwrite'

Select 'exec sp_addextendedproc' + name + ', ''' + dll + ''''
From # temp