Microsoft Internet Business Development Kit/PRODUCT_CD.iso/sqlsvr/ppc/xpstar.sql

Text File | 1995-12-08 | 7.5 KB | 253 lines

/********************************************************************************************/
/* xp_regread '<HKEY_LOCAL_MACHINE | HKEY_USERS>','<Key>','<Value>'                            */
/*                                                                                            */
/* eg:                                                                                        */
/*   xp_regread 'HKEY_LOCAL_MACHINE','SOFTWARE\Microsoft\MSSQLServer\Server','AuditLevel'    */
/*                                                                                            */
/********************************************************************************************/

use master
go

print 'Creating extended stored procedure xp_regread'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_regread')
  EXEC sp_dropextendedproc 'xp_regread'
go
sp_addextendedproc 'xp_regread','xpstar.dll'
go
grant execute on xp_regread to repl_subscriber
go

print 'Creating extended stored procedure xp_regwrite'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_regwrite')
  EXEC sp_dropextendedproc 'xp_regwrite'
go
sp_addextendedproc 'xp_regwrite','xpstar.dll'
go
print 'Creating extended stored procedure xp_regdeletevalue'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_regdeletevalue')
  EXEC sp_dropextendedproc 'xp_regdeletevalue'
go
sp_addextendedproc 'xp_regdeletevalue','xpstar.dll'
go

print 'Creating extended stored procedure xp_regaddmultistring'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_regaddmultistring')
  EXEC sp_dropextendedproc 'xp_regaddmultistring'
go
sp_addextendedproc 'xp_regaddmultistring','xpstar.dll'
go

print 'Creating extended stored procedure xp_regremovemultistring'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_regremovemultistring')
  EXEC sp_dropextendedproc 'xp_regremovemultistring'
go
sp_addextendedproc 'xp_regremovemultistring','xpstar.dll'
go

print 'Creating extended stored procedure xp_regenumvalues'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_regenumvalues')
  EXEC sp_dropextendedproc 'xp_regenumvalues'
go
sp_addextendedproc 'xp_regenumvalues','xpstar.dll'
go

print 'Creating extended stored procedure xp_readerrorlog'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_readerrorlog')
  EXEC sp_dropextendedproc 'xp_readerrorlog'
go
sp_addextendedproc 'xp_readerrorlog','xpstar.dll'
go

print 'Creating extended stored procedure xp_enumerrorlogs'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_enumerrorlogs')
  EXEC sp_dropextendedproc 'xp_enumerrorlogs'
go
sp_addextendedproc 'xp_enumerrorlogs','xpstar.dll'
go

print 'Creating extended stored procedure xp_perfsample'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_perfsample')
  EXEC sp_dropextendedproc 'xp_perfsample'
go
sp_addextendedproc 'xp_perfsample','xpstar.dll'
go

print 'Creating extended stored procedure xp_perfstart'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_perfstart')
  EXEC sp_dropextendedproc 'xp_perfstart'
go
sp_addextendedproc 'xp_perfstart','xpstar.dll'
go

print 'Creating extended stored procedure xp_perfend'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_perfend')
  EXEC sp_dropextendedproc 'xp_perfend'
go
sp_addextendedproc 'xp_perfend','xpstar.dll'
go

print 'Creating extended stored procedure xp_perfmonitor'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_perfmonitor')
  EXEC sp_dropextendedproc 'xp_perfmonitor'
go
sp_addextendedproc 'xp_perfmonitor','xpstar.dll'
go

print 'Creating extended stored procedure xp_servicecontrol'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_servicecontrol')
  EXEC sp_dropextendedproc 'xp_servicecontrol'
go
sp_addextendedproc 'xp_servicecontrol','xpstar.dll'
go

print 'Creating extended stored procedure xp_monitorsignal'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_monitorsignal')
  EXEC sp_dropextendedproc 'xp_monitorsignal'
go
sp_addextendedproc 'xp_monitorsignal','xpstar.dll'
go

print 'Creating extended stored procedure xp_availablemedia'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_availablemedia')
  EXEC sp_dropextendedproc 'xp_availablemedia'
go
sp_addextendedproc 'xp_availablemedia','xpstar.dll'
go

print 'Creating extended stored procedure xp_dirtree'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_dirtree')
  EXEC sp_dropextendedproc 'xp_dirtree'
go
sp_addextendedproc 'xp_dirtree','xpstar.dll'
go

print 'Creating extended stored procedure xp_eventlog'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_eventlog')
  EXEC sp_dropextendedproc 'xp_eventlog'
go
sp_addextendedproc 'xp_eventlog','xpstar.dll'
go

print 'Creating extended stored procedure xp_fixeddrives'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_fixeddrives')
  EXEC sp_dropextendedproc 'xp_fixeddrives'
go
sp_addextendedproc 'xp_fixeddrives','xpstar.dll'
go

print 'Creating extended stored procedure xp_subdirs'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_subdirs')
  EXEC sp_dropextendedproc 'xp_subdirs'
go
sp_addextendedproc 'xp_subdirs','xpstar.dll'
go

print 'Creating extended stored procedure xp_enumqueuedtasks'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_enumqueuedtasks')
  EXEC sp_dropextendedproc 'xp_enumqueuedtasks'
go
sp_addextendedproc 'xp_enumqueuedtasks','xpstar.dll'
go

print 'Creating extended stored procedure xp_schedulersignal'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_schedulersignal')
  EXEC sp_dropextendedproc 'xp_schedulersignal'
go
sp_addextendedproc 'xp_schedulersignal','xpstar.dll'
go
grant execute on xp_schedulersignal to repl_subscriber
go
if exists (select * from master.dbo.sysobjects where name = 'xp_vbarun')
  EXEC sp_dropextendedproc 'xp_vbarun'
go
sp_addextendedproc 'xp_vbarun','xpstar.dll'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_getnetname')
  EXEC sp_dropextendedproc 'xp_getnetname'
go
sp_addextendedproc 'xp_getnetname','xpstar.dll'
go
grant execute on xp_getnetname to public
go

print 'Creating extended stored procedure xp_snmp_getstate'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_snmp_getstate')
  EXEC sp_dropextendedproc 'xp_snmp_getstate'
go
sp_addextendedproc 'xp_snmp_getstate','xpstar.dll'
go
grant execute on xp_snmp_getstate to public
go

print 'Creating extended stored procedure xp_snmp_raisetrap'
go
if exists (select * from master.dbo.sysobjects where name = 'xp_snmp_raisetrap')
  EXEC sp_dropextendedproc 'xp_snmp_raisetrap'
go
sp_addextendedproc 'xp_snmp_raisetrap','xpstar.dll'
go
grant execute on xp_snmp_raisetrap to public
go

if exists(select * from sysobjects where type = 'X' and name = 'xp_sqlregister')
begin
    exec sp_dropextendedproc 'xp_sqlregister'
    print 'dropping xp_sqlregister'
end
go

exec sp_addextendedproc 'xp_sqlregister', 'xpstar.dll'
go

grant exec on xp_sqlregister to public
go

if exists(select * from sysobjects where type = 'X' and name = 'xp_sqlinventory')
begin
    exec sp_dropextendedproc 'xp_sqlinventory'
    print 'dropping xp_sqlinventory'
end
go

exec sp_addextendedproc 'xp_sqlinventory', 'xpstar.dll'
go

if exists (select * from sysobjects where name like 'sp_sqlregister' and type = 'P')
begin
    drop procedure sp_sqlregister
    print 'dropping old sp_sqlregister'
end
go

create proc sp_sqlregister as
begin
    exec master.dbo.xp_sqlregister
end
go

sp_makestartup 'sp_sqlregister'
go