Microsoft Internet Business Development Kit/PRODUCT_CD.iso/sqlsvr/i386/dropall.sql

Text File | 1995-12-07 | 27.7 KB | 717 lines

-- - ----
/*
** DROPALL.SQL         1995/12/06 17:51
**
** Removes all system procedures, catalog procedures, extended procedures,
** etc. in preparation for an upgrade.
**
****************************************************************************
** Copyright (C) 1994, 1995, 1996 - Microsoft Corporation                  *
****************************************************************************
*/

go
use master
set nocount on
go

dump tran master with no_log
go
print ''
print 'Dropping stored procedures'
print ''
go

if exists (select * from sysobjects where name = 'MS_sqlctrs_locks' and sysstat & 0xf = 4)
    drop proc MS_sqlctrs_locks
go
if exists (select * from sysobjects where name = 'MS_sqlctrs_users' and sysstat & 0xf = 4)
    drop proc MS_sqlctrs_users
go
if exists (select * from sysobjects where name = 'sp_column_privileges' and sysstat & 0xf = 4)
    drop proc sp_column_privileges
go
if exists (select * from sysobjects where name = 'sp_columns' and sysstat & 0xf = 4)
    drop proc sp_columns
go
if exists (select * from sysobjects where name = 'sp_databases' and sysstat & 0xf = 4)
    drop proc sp_databases
go
if exists (select * from sysobjects where name = 'sp_datatype_info' and sysstat & 0xf = 4)
    drop proc sp_datatype_info
go
if exists (select * from sysobjects where name = 'sp_fkeys' and sysstat & 0xf = 4)
    drop proc sp_fkeys
go

/*
if exists (select * from sysobjects where name = 'sp_helpsql' and sysstat & 0xf = 4)
    drop proc sp_helpsql
*/

dump tran master with no_log
go
if exists (select * from sysobjects where name = 'sp_pkeys' and sysstat & 0xf = 4)
    drop proc sp_pkeys
go
if exists (select * from sysobjects where name = 'sp_server_info' and sysstat & 0xf = 4)
    drop proc sp_server_info
go
if exists (select * from sysobjects where name = 'sp_special_columns' and sysstat & 0xf = 4)
    drop proc sp_special_columns
go
if exists (select * from sysobjects where name = 'sp_sproc_columns' and sysstat & 0xf = 4)
    drop proc sp_sproc_columns
go
if exists (select * from sysobjects where name = 'sp_statistics' and sysstat & 0xf = 4)
    drop proc sp_statistics
go
if exists (select * from sysobjects where name = 'sp_stored_procedures' and sysstat & 0xf = 4)
    drop proc sp_stored_procedures
go
if exists (select * from sysobjects where name = 'sp_table_privileges' and sysstat & 0xf = 4)
    drop proc sp_table_privileges
go
if exists (select * from sysobjects where name = 'sp_tables' and sysstat & 0xf = 4)
    drop proc sp_tables
go
if exists (select * from sysobjects where name = 'sp_abort_xact' and sysstat & 0xf = 4)
    drop procedure sp_abort_xact
go
if exists (select * from sysobjects where name = 'sp_addalias' and sysstat & 0xf = 4)
    drop procedure sp_addalias
go
if exists (select * from sysobjects where name = 'sp_addarticle' and sysstat & 0xf = 4)
    drop procedure sp_addarticle
go
if exists (select * from sysobjects where name = 'sp_addpublisher' and sysstat & 0xf = 4)
    drop procedure sp_addpublisher
go
if exists (select * from sysobjects where name = 'sp_articlecolumn' and sysstat & 0xf = 4)
    drop procedure sp_articlecolumn
go
if exists (select * from sysobjects where name = 'sp_addextendedproc' and sysstat & 0xf = 4)
    drop procedure sp_addextendedproc
go
if exists (select * from sysobjects where name = 'sp_addgroup' and sysstat & 0xf = 4)
    drop procedure sp_addgroup
go
if exists (select * from sysobjects where name = 'sp_addlanguage' and sysstat & 0xf = 4)
    drop procedure sp_addlanguage
go
if exists (select * from sysobjects where name = 'sp_addlogin' and sysstat & 0xf = 4)
    drop procedure sp_addlogin
go
if exists (select * from sysobjects where name = 'sp_addmessage' and sysstat & 0xf = 4)
    drop procedure sp_addmessage
go
if exists (select * from sysobjects where name = 'sp_altermessage' and sysstat & 0xf = 4)
    drop procedure sp_altermessage
go
if exists (select * from sysobjects where name = 'sp_addpublication' and sysstat & 0xf = 4)
    drop procedure sp_addpublication
go
if exists (select * from sysobjects where name = 'sp_addremotelogin' and sysstat & 0xf = 4)
    drop procedure sp_addremotelogin
go
if exists (select * from sysobjects where name = 'sp_addsegment' and sysstat & 0xf = 4)
    drop procedure sp_addsegment
go
if exists (select * from sysobjects where name = 'sp_addserver' and sysstat & 0xf = 4)
    drop procedure sp_addserver
go
if exists (select * from sysobjects where name = 'sp_addsubscriber' and sysstat & 0xf = 4)
    drop procedure sp_addsubscriber
go
if exists (select * from sysobjects where name = 'sp_addsubscription' and sysstat & 0xf = 4)
    drop procedure sp_addsubscription
go
if exists (select * from sysobjects where name = 'sp_addtype' and sysstat & 0xf = 4)
    drop procedure sp_addtype
go
if exists (select * from sysobjects where name = 'sp_addumpdevice' and sysstat & 0xf = 4)
    drop procedure sp_addumpdevice
go
if exists (select * from sysobjects where name = 'sp_adduser' and sysstat & 0xf = 4)
    drop procedure sp_adduser
go
if exists (select * from sysobjects where name = 'sp_articlefilter' and sysstat & 0xf = 4)
    drop procedure sp_articlefilter
go
if exists (select * from sysobjects where name = 'sp_articletextcol' and sysstat & 0xf = 4)
    drop procedure sp_articletextcol
go

if exists (select * from sysobjects where name = 'sp_textcolstatus' and sysstat & 0xf = 4)
    drop procedure sp_textcolstatus
go

if exists (select * from sysobjects where name = 'sp_articleview' and sysstat & 0xf = 4)
    drop procedure sp_articleview
go
if exists (select * from sysobjects where name = 'sp_bindefault' and sysstat & 0xf = 4)
    drop procedure sp_bindefault
go
if exists (select * from sysobjects where name = 'sp_bindrule' and sysstat & 0xf = 4)
    drop procedure sp_bindrule
go
if exists (select * from sysobjects where name = 'sp_certify_removable' and sysstat & 0xf = 4)
    drop procedure sp_certify_removable
go
if exists (select * from sysobjects where name = 'sp_changearticle' and sysstat & 0xf = 4)
    drop procedure sp_changearticle
go
if exists (select * from sysobjects where name = 'sp_changedbowner' and sysstat & 0xf = 4)
    drop procedure sp_changedbowner
go
if exists (select * from sysobjects where name = 'sp_changegroup' and sysstat & 0xf = 4)
    drop procedure sp_changegroup
go
if exists (select * from sysobjects where name = 'sp_changepublication' and sysstat & 0xf = 4)
    drop procedure sp_changepublication
go
if exists (select * from sysobjects where name = 'sp_changesubscriber' and sysstat & 0xf = 4)
    drop procedure sp_changesubscriber
go
if exists (select * from sysobjects where name = 'sp_changesubscription' and sysstat & 0xf = 4)
    drop procedure sp_changesubscription
go
if exists (select * from sysobjects where name = 'sp_hcchangesubstatus1' and sysstat & 0xf = 4)
    drop procedure sp_hcchangesubstatus1
go
if exists (select * from sysobjects where name = 'sp_hcchangesubstatus2' and sysstat & 0xf = 4)
    drop procedure sp_hcchangesubstatus2
go
if exists (select * from sysobjects where name = 'sp_changesubstatus' and sysstat & 0xf = 4)
    drop procedure sp_changesubstatus
go
if exists (select * from sysobjects where name = 'sp_checknames' and sysstat & 0xf = 4)
    drop procedure sp_checknames
go
if exists (select * from sysobjects where name = 'sp_check_objects' and sysstat & 0xf = 4)
    drop procedure sp_check_objects
go
if exists (select * from sysobjects where name = 'sp_check_removable' and sysstat & 0xf = 4)
    drop procedure sp_check_removable
go
if exists (select * from sysobjects where name = 'sp_chklangparam' and sysstat & 0xf = 4)
    drop procedure sp_chklangparam
go
if exists (select * from sysobjects where name = 'sp_commit_xact' and sysstat & 0xf = 4)
    drop procedure sp_commit_xact
go
if exists (select * from sysobjects where name = 'sp_commonkey' and sysstat & 0xf = 4)
    drop procedure sp_commonkey
go
if exists (select * from sysobjects where name = 'sp_configure' and sysstat & 0xf = 4)
    drop procedure sp_configure
go
if exists (select * from sysobjects where name = 'sp_create_removable' and sysstat & 0xf = 4)
    drop procedure sp_create_removable
go
if exists (select * from sysobjects where name = 'sp_create_distribution_tables' and sysstat & 0xf = 4)
    drop procedure sp_create_distribution_tables
go
dump tran master with no_log
go
if exists (select * from sysobjects where name = 'sp_data_init' and sysstat & 0xf = 4)
    drop procedure sp_data_init
go
if exists (select * from sysobjects where name = 'sp_db_upgrade' and sysstat & 0xf = 4)
    drop procedure sp_db_upgrade
go
if exists (select * from sysobjects where name = 'sp_db_upgrade1' and sysstat & 0xf = 4)
    drop procedure sp_db_upgrade1
go
if exists (select * from sysobjects where name = 'sp_db_upgrade2' and sysstat & 0xf = 4)
    drop procedure sp_db_upgrade2
go
if exists (select * from sysobjects where name = 'sp_coalesce_fragments' and sysstat & 0xf = 4)
    drop procedure sp_coalesce_fragments
go
if exists (select * from sysobjects where name = 'sp_dbinstall' and sysstat & 0xf = 4)
    drop procedure sp_dbinstall
go
if exists (select * from sysobjects where name = 'sp_dboption' and sysstat & 0xf = 4)
    drop procedure sp_dboption
go
if exists (select * from sysobjects where name = 'sp_dbremove' and sysstat & 0xf = 4)
    drop procedure sp_dbremove
go
if exists (select * from sysobjects where name = 'sp_defaultdb' and sysstat & 0xf = 4)
    drop procedure sp_defaultdb
go
if exists (select * from sysobjects where name = 'sp_defaultlanguage' and sysstat & 0xf = 4)
    drop procedure sp_defaultlanguage
go
if exists (select * from sysobjects where name = 'sp_depends' and sysstat & 0xf = 4)
    drop procedure sp_depends
go
if exists (select * from sysobjects where name = 'sp_devcreate' and sysstat & 0xf = 4)
    drop procedure sp_devcreate
go
if exists (select * from sysobjects where name = 'sp_devoption' and sysstat & 0xf = 4)
    drop procedure sp_devoption
go
if exists (select * from sysobjects where name = 'sp_diskdefault' and sysstat & 0xf = 4)
    drop procedure sp_diskdefault
go
if exists (select * from sysobjects where name = 'sp_distcounters' and sysstat & 0xf = 4)
    drop procedure sp_distcounters
go
if exists (select * from sysobjects where name = 'sp_dropalias' and sysstat & 0xf = 4)
    drop procedure sp_dropalias
go
if exists (select * from sysobjects where name = 'sp_droparticle' and sysstat & 0xf = 4)
    drop procedure sp_droparticle
go
if exists (select * from sysobjects where name = 'sp_dropdevice' and sysstat & 0xf = 4)
    drop procedure sp_dropdevice
go
if exists (select * from sysobjects where name = 'sp_dropdumpdevice' and sysstat & 0xf = 4)
    drop procedure sp_dropdumpdevice
go
if exists (select * from sysobjects where name = 'sp_dropextendedproc' and sysstat & 0xf = 4)
    drop procedure sp_dropextendedproc
go
if exists (select * from sysobjects where name = 'sp_dropgroup' and sysstat & 0xf = 4)
    drop procedure sp_dropgroup
go
if exists (select * from sysobjects where name = 'sp_dropkey' and sysstat & 0xf = 4)
    drop procedure sp_dropkey
go
if exists (select * from sysobjects where name = 'sp_droplanguage' and sysstat & 0xf = 4)
    drop procedure sp_droplanguage
go
if exists (select * from sysobjects where name = 'sp_droplogin' and sysstat & 0xf = 4)
    drop procedure sp_droplogin
go
if exists (select * from sysobjects where name = 'sp_dropmessage' and sysstat & 0xf = 4)
    drop procedure sp_dropmessage
go
if exists (select * from sysobjects where name = 'sp_droppublication' and sysstat & 0xf = 4)
    drop procedure sp_droppublication
go
if exists (select * from sysobjects where name = 'sp_droppublisher' and sysstat & 0xf = 4)
    drop procedure sp_droppublisher
go
if exists (select * from sysobjects where name = 'sp_dropremotelogin' and sysstat & 0xf = 4)
    drop procedure sp_dropremotelogin
go
if exists (select * from sysobjects where name = 'sp_dropsegment' and sysstat & 0xf = 4)
    drop procedure sp_dropsegment
go
if exists (select * from sysobjects where name = 'sp_dropserver' and sysstat & 0xf = 4)
    drop procedure sp_dropserver
go
if exists (select * from sysobjects where name = 'sp_dropsubscriber' and sysstat & 0xf = 4)
    drop procedure sp_dropsubscriber
go
if exists (select * from sysobjects where name = 'sp_dropsubscription' and sysstat & 0xf = 4)
    drop procedure sp_dropsubscription
go
if exists (select * from sysobjects where name = 'sp_droptype' and sysstat & 0xf = 4)
    drop procedure sp_droptype
go
if exists (select * from sysobjects where name = 'sp_dropuser' and sysstat & 0xf = 4)
    drop procedure sp_dropuser
go
if exists (select * from sysobjects where name = 'sp_dsninfo' and sysstat & 0xf = 4)
    drop procedure sp_dsninfo
go
if exists (select * from sysobjects where name = 'sp_enumfullsubscribers' and sysstat & 0xf = 4)
    drop procedure sp_enumfullsubscribers
go
if exists (select * from sysobjects where name = 'sp_enumdsn' and sysstat & 0xf = 4)
    drop procedure sp_enumdsn
go
if exists (select * from sysobjects where name = 'sp_extendsegment' and sysstat & 0xf = 4)
    drop procedure sp_extendsegment
go
if exists (select * from sysobjects where name = 'sp_fixindex' and sysstat & 0xf = 4)
    drop procedure sp_fixindex
go
if exists (select * from sysobjects where name = 'sp_foreignkey' and sysstat & 0xf = 4)
    drop procedure sp_foreignkey
go
if exists (select * from sysobjects where name = 'sp_help' and sysstat & 0xf = 4)
    drop procedure sp_help
go
if exists (select * from sysobjects where name = 'sp_helparticle' and sysstat & 0xf = 4)
    drop procedure sp_helparticle
go
if exists (select * from sysobjects where name = 'sp_helparticlecolumns' and sysstat & 0xf = 4)
    drop procedure sp_helparticlecolumns
go
if exists (select * from sysobjects where name = 'sp_cnst_csr' and sysstat & 0xf = 4)
    drop procedure sp_cnst_csr
go
if exists (select * from sysobjects where name = 'sp_helpconstraint' and sysstat & 0xf = 4)
    drop procedure sp_helpconstraint
go
if exists (select * from sysobjects where name = 'sp_helpdb' and sysstat & 0xf = 4)
    drop procedure sp_helpdb
go
if exists (select * from sysobjects where name = 'sp_helpdevice' and sysstat & 0xf = 4)
    drop procedure sp_helpdevice
go
if exists (select * from sysobjects where name = 'sp_helpdistributor' and sysstat & 0xf = 4)
    drop procedure sp_helpdistributor
go
if exists (select * from sysobjects where name = 'sp_helpextendedproc' and sysstat & 0xf = 4)
    drop procedure sp_helpextendedproc
go
if exists (select * from sysobjects where name = 'sp_helpgroup' and sysstat & 0xf = 4)
    drop procedure sp_helpgroup
go
if exists (select * from sysobjects where name = 'sp_helpindex' and sysstat & 0xf = 4)
    drop procedure sp_helpindex
go
if exists (select * from sysobjects where name = 'sp_helpjoins' and sysstat & 0xf = 4)
    drop procedure sp_helpjoins
go
dump tran master with no_log
go
if exists (select * from sysobjects where name = 'sp_helpkey' and sysstat & 0xf = 4)
    drop procedure sp_helpkey
go
if exists (select * from sysobjects where name = 'sp_helplanguage' and sysstat & 0xf = 4)
    drop procedure sp_helplanguage
go
if exists (select * from sysobjects where name = 'sp_helplog' and sysstat & 0xf = 4)
    drop procedure sp_helplog
go
if exists (select * from sysobjects where name = 'sp_helpremotelogin' and sysstat & 0xf = 4)
    drop procedure sp_helpremotelogin
go
if exists (select * from sysobjects where name = 'sp_helprotect' and sysstat & 0xf = 4)
    drop procedure sp_helprotect
go
if exists (select * from sysobjects where name = 'sp_helppublication' and sysstat & 0xf = 4)
    drop procedure sp_helppublication
go
if exists (select * from sysobjects where name = 'sp_helppublicationsync' and sysstat & 0xf = 4)
    drop procedure sp_helppublicationsync
go
if exists (select * from sysobjects where name = 'sp_helppublisheddb' and sysstat & 0xf = 4)
    drop procedure sp_helppublisheddb
go
if exists (select * from sysobjects where name = 'sp_helpreplicationdb' and sysstat & 0xf = 4)
    drop procedure sp_helpreplicationdb
go
if exists (select * from sysobjects where name = 'sp_helpsegment' and sysstat & 0xf = 4)
    drop procedure sp_helpsegment
go
if exists (select * from sysobjects where name = 'sp_helpserver' and sysstat & 0xf = 4)
    drop procedure sp_helpserver
go
if exists (select * from sysobjects where name = 'sp_helpstartup' and sysstat & 0xf = 4)
    drop procedure sp_helpstartup
go
if exists (select * from sysobjects where name = 'sp_helpsort' and sysstat & 0xf = 4)
    drop procedure sp_helpsort
go
if exists (select * from sysobjects where name = 'sp_helpsubscriberinfo' and sysstat & 0xf = 4)
    drop procedure sp_helpsubscriberinfo
go
if exists (select * from sysobjects where name = 'sp_helpsubscription' and sysstat & 0xf = 4)
    drop procedure sp_helpsubscription
go
if exists (select * from sysobjects where name = 'sp_helptext' and sysstat & 0xf = 4)
    drop procedure sp_helptext
go
if exists (select * from sysobjects where name = 'sp_helpuser' and sysstat & 0xf = 4)
    drop procedure sp_helpuser
go
if exists (select * from sysobjects where name = 'sp_lock' and sysstat & 0xf = 4)
    drop procedure sp_lock
go
if exists (select * from sysobjects where name = 'sp_lockinfo' and sysstat & 0xf = 4)
    drop procedure sp_lockinfo
go
if exists (select * from sysobjects where name = 'sp_logdevice' and sysstat & 0xf = 4)
    drop procedure sp_logdevice
go
if exists (select * from sysobjects where name = 'sp_lookup' and sysstat & 0xf = 4)
    drop procedure sp_lookup
go
if exists (select * from sysobjects where name = 'sp_makestartup' and sysstat & 0xf = 4)
    drop procedure sp_makestartup
go
if exists (select * from sysobjects where name = 'sp_markreport' and sysstat & 0xf = 4)
    drop procedure sp_markreport
go
if exists (select * from sysobjects where name = 'sp_monitor' and sysstat & 0xf = 4)
    drop procedure sp_monitor
go
if exists (select * from sysobjects where name = 'sp_MSdbuserprofile' and sysstat & 0xf = 4)
    drop procedure sp_MSdbuserprofile
go
if exists (select * from sysobjects where name = 'sp_MShelpindex' and sysstat & 0xf = 4)
    drop procedure sp_MShelpindex
go

if exists (select * from sysobjects where name = 'sp_MSobjectprivs' and sysstat & 0xf = 4)
    drop procedure sp_MShelpindex
go

if exists (select * from sysobjects where name = 'sp_namecrack' and sysstat & 0xf = 4)
    drop procedure sp_namecrack
go
if exists (select * from sysobjects where name = 'sp_objcheck' and sysstat & 0xf = 4)
    drop procedure sp_objcheck
go
if exists (select * from sysobjects where name = 'sp_objectsegment' and sysstat & 0xf = 4)
    drop procedure sp_objectsegment
go
if exists (select * from sysobjects where name = 'sp_password' and sysstat & 0xf = 4)
    drop procedure sp_password
go
if exists (select * from sysobjects where name = 'sp_placeobject' and sysstat & 0xf = 4)
    drop procedure sp_placeobject
go
if exists (select * from sysobjects where name = 'sp_primarykey' and sysstat & 0xf = 4)
    drop procedure sp_primarykey
go
if exists (select * from sysobjects where name = 'sp_probe_xact' and sysstat & 0xf = 4)
    drop procedure sp_probe_xact
go
if exists (select * from sysobjects where name = 'sp_processinfo' and sysstat & 0xf = 4)
    drop procedure sp_processinfo
go
if exists (select * from sysobjects where name = 'sp_processmail' and sysstat & 0xf = 4)
    drop procedure sp_processmail
go
if exists (select * from sysobjects where name = 'sp_publishdb' and sysstat & 0xf = 4)
    drop procedure sp_publishdb
go
if exists (select * from sysobjects where name = 'sp_recompile' and sysstat & 0xf = 4)
    drop procedure sp_recompile
go
if exists (select * from sysobjects where name = 'sp_remoteoption' and sysstat & 0xf = 4)
    drop procedure sp_remoteoption
go
if exists (select * from sysobjects where name = 'sp_remove_xact' and sysstat & 0xf = 4)
    drop procedure sp_remove_xact
go
if exists (select * from sysobjects where name = 'sp_rename' and sysstat & 0xf = 4)
    drop procedure sp_rename
go
if exists (select * from sysobjects where name = 'sp_renamedb' and sysstat & 0xf = 4)
    drop procedure sp_renamedb
go
if exists (select * from sysobjects where name = 'sp_replica' and sysstat & 0xf = 4)
    drop procedure sp_replica
go
if exists (select * from sysobjects where name = 'sp_replsync' and sysstat & 0xf = 4)
    drop procedure sp_replsync
go
if exists (select * from sysobjects where name = 'sp_replcmds' and sysstat & 0xf = 4)
    drop procedure sp_replcmds
go
if exists (select * from sysobjects where name = 'sp_replcounters' and sysstat & 0xf = 4)
    drop procedure sp_replcounters
go
if exists (select * from sysobjects where name = 'sp_repldone' and sysstat & 0xf = 4)
    drop procedure sp_repldone
go
if exists (select * from sysobjects where name = 'sp_replflush' and sysstat & 0xf = 4)
    drop procedure sp_replflush
go
if exists (select * from sysobjects where name = 'sp_replstatus' and sysstat & 0xf = 4)
    drop procedure sp_replstatus
go
if exists (select * from sysobjects where name = 'sp_repltrans' and sysstat & 0xf = 4)
    drop procedure sp_repltrans
go
if exists (select * from sysobjects where name = 'sp_schedulersignal' and sysstat & 0xf = 4)
    drop procedure sp_schedulersignal
go
if exists (select * from sysobjects where name = 'sp_schema_modify' and sysstat & 0xf = 4)
    drop procedure sp_schema_modify
go
if exists (select * from sysobjects where name = 'sp_scan_xact' and sysstat & 0xf = 4)
    drop procedure sp_scan_xact
go
if exists (select * from sysobjects where name = 'sp_setnetname' and sysstat & 0xf = 4)
    drop procedure sp_setnetname
go
if exists (select * from sysobjects where name = 'sp_serveroption' and sysstat & 0xf = 4)
    drop procedure sp_serveroption
go
if exists (select * from sysobjects where name = 'sp_setlangalias' and sysstat & 0xf = 4)
    drop procedure sp_setlangalias
go
if exists (select * from sysobjects where name = 'sp_spaceused' and sysstat & 0xf = 4)
    drop procedure sp_spaceused
go
if exists (select * from sysobjects where name = 'sp_sqlexec' and sysstat & 0xf = 4)
    drop procedure sp_sqlexec
go
if exists (select * from sysobjects where name = 'sp_start_xact' and sysstat & 0xf = 4)
    drop procedure sp_start_xact
go
if exists (select * from sysobjects where name = 'sp_stat_xact' and sysstat & 0xf = 4)
    drop procedure sp_stat_xact
go
if exists (select * from sysobjects where name = 'sp_subscribe' and sysstat & 0xf = 4)
    drop procedure sp_subscribe
go
if exists (select * from sysobjects where name = 'sp_unbindefault' and sysstat & 0xf = 4)
    drop procedure sp_unbindefault
go
if exists (select * from sysobjects where name = 'sp_unbindrule' and sysstat & 0xf = 4)
    drop procedure sp_unbindrule
go
if exists (select * from sysobjects where name = 'sp_unmakestartup' and sysstat & 0xf = 4)
    drop procedure sp_unmakestartup
go
if exists (select * from sysobjects where name = 'sp_unsubscribe' and sysstat & 0xf = 4)
    drop procedure sp_unsubscribe
go
if exists (select * from sysobjects where name = 'sp_validaltlang' and sysstat & 0xf = 4)
    drop procedure sp_validaltlang
go
if exists (select * from sysobjects where name = 'sp_validlang' and sysstat & 0xf = 4)
    drop procedure sp_validlang
go
if exists (select * from sysobjects where name = 'sp_validname' and sysstat & 0xf = 4)
    drop procedure sp_validname
go
if exists (select * from sysobjects where name = 'sp_who' and sysstat & 0xf = 4)
    drop procedure sp_who
go

dump tran master with no_log
go

if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MShelpcolumns')
    drop procedure sp_MShelpcolumns
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MShelptype')
    drop procedure sp_MShelptype
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MSdependencies')
    drop procedure sp_MSdependencies
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MStablespace')
    drop procedure sp_MStablespace
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MSindexspace')
    drop procedure sp_MSindexspace
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MSuniquename')
    drop procedure sp_MSuniquename
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MSkilldb')
    drop procedure sp_MSkilldb
go

if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MSgetalertinfo')
    drop procedure sp_MSgetalertinfo
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MSsetalertinfo')
    drop procedure sp_MSsetalertinfo
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MSgetexecinfo')
    drop procedure sp_MSgetexecinfo
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MSsetexecinfo')
    drop procedure sp_MSsetexecinfo
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MStablekeys')
    drop procedure sp_MStablekeys
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MStablechecks')
    drop procedure sp_MStablechecks
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MStablerefs')
    drop procedure sp_MStablerefs
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MSsettopology')
    drop procedure sp_MSsettopology
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MSfilterclause')
    drop procedure sp_MSfilterclause
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MSmatchkey')
    drop procedure sp_MSmatchkey
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MSsubscriptions')
    drop procedure sp_MSsubscriptions
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MSforeachdb')
    drop procedure sp_MSforeachdb
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MSforeachtable')
    drop procedure sp_MSforeachtable
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MSforeach_worker')
    drop procedure sp_MSforeach_worker
go
if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MSloginmappings')
    drop procedure sp_MSloginmappings
go

if exists (select * from sysobjects where sysstat & 0x0f = 4 and name = 'sp_MSSQLOLE_version')
    drop procedure sp_MSSQLOLE_version
go


/***********  Do not lose data....
print ''
print 'Dropping tables'
print ''
--go


--if exists (select * from sysobjects where name = 'helpsql' and sysstat & 0xf = 3)
-- !    drop table helpsql


if exists (select * from sysobjects where name = 'MSdatatype_info' and sysstat & 0xf = 3)
    drop table MSdatatype_info

if exists (select * from sysobjects where name = 'MSdatatype_info_ext' and sysstat & 0xf = 3)
    drop table MSdatatype_info_ext

if exists (select * from sysobjects where name = 'MSobjects' and sysstat & 0xf = 3)
    drop table MSobjects

if exists (select * from sysobjects where name = 'MSserver_info' and sysstat & 0xf = 3)
    drop table MSserver_info

if exists (select * from sysobjects where name = 'MStable_types' and sysstat & 0xf = 3)
    drop table MStable_types

if exists (select * from sysobjects where name = 'spt_committab' and sysstat & 0xf = 3)
    drop table spt_committab

if exists (select * from sysobjects where name = 'spt_datatype_info' and sysstat & 0xf = 3)
    drop table spt_datatype_info

if exists (select * from sysobjects where name = 'spt_datatype_info_ext' and sysstat & 0xf = 3)
    drop table spt_datatype_info_ext

if exists (select * from sysobjects where name = 'spt_monitor' and sysstat & 0xf = 3)
    drop table spt_monitor

if exists (select * from sysobjects where name = 'spt_server_info' and sysstat & 0xf = 3)
    drop table spt_server_info

if exists (select * from sysobjects where name = 'spt_table_types' and sysstat & 0xf = 3)
    drop table spt_table_types

if exists (select * from sysobjects where name = 'spt_values' and sysstat & 0xf = 3)
    drop table spt_values
*************/

go
dump tran master with no_log
go

print 'Done.'
go
-- - ----