March 7, 2006 at 3:36 am
March 8, 2006 at 2:35 am
Which version are you on?
A couple of things to try;
Try restarting SQL Server, try disabling replication then re-enabling it sounds like a famous SQL nudge it till it realises it's not updated itself.
Luck,
dgm
March 8, 2006 at 6:05 am
On the subscriber run
sp_removedbreplication [ @dbname = ] 'dbname'
verify that this worked by running these queries:
Select 'drop table ' + name from sysobjects where name like '%conflict%' and type='u'
Select 'drop trigger ' + name from sysobjects where type = 'tr' and status < 0 and category = 2
Select 'drop proc ' + name from sysobjects where name like 'sp_%' and type ='p' and category = 2
Select 'drop view ' + name from sysobjects where name like 'tsvw%' and type ='v' and category = 2
Select 'drop view ' + name from sysobjects where name like 'ctsv%' and type ='v' and category = 2
Select 'drop table ' + name from sysobjects where name like 'MSMerge%' and type='u'
If rows are returned you can run the OUTPUT from the above queries.
2) Follow the same procedure on the PUBLISHER
3)
use distribution
select * from msmerge_agents where publication = ‘<yourpublicationdb>'
select * from msmerge_subscriptions where publisher_db ='<yourpublicationdb>'
select * from mspublications where publication = '<yourpublication>'
-- run the replication cleanup agents
March 8, 2006 at 11:00 am
If I run this, it will delete not only mu replication, but half of my stored procedures:
drop proc sp_MSchunkgeneration
drop proc sp_helpsql
drop proc sp_MSgettools_path
drop proc sp_validatemergesubscription
drop proc sp_scriptupdproc
drop proc sp_check_publication_access
drop proc sp_datatype_info
drop proc sp_MSregistersubscription
drop proc sp_monitor
drop proc sp_replicationoption
drop proc sp_validatemergepublication
drop proc sp_MS_upd_sysobj_category
drop proc sp_scriptmappedupdproc
drop proc sp_MSget_agent_names
drop proc sp_MSunregistersubscription
drop proc sp_helpreplicationoption
drop proc sp_MScleanup_conflict
drop proc sp_db_upgrade
drop proc sp_scriptdynamicupdproc
drop proc sp_MSinit_replication_perfmon
drop proc sp_MSsubscription_enabled_for_syncmgr
drop proc sp_recompile
drop proc sp_MSgetreplnick
drop proc sp_generatefilters
drop proc sp_scriptxupdproc
drop proc sp_readerrorlog
drop proc sp_MSget_jobstate
drop proc sp_remoteoption
drop proc sp_MSreplcheck_publish
drop proc sp_MShelpmergeconflictcounts
drop proc sp_MSscriptmvastablenci
drop proc sp_MSflush_access_cache
drop proc sp_fkeys
drop proc sp_MSscript_pkvar_assignment
drop proc sp_invalidate_textptr
drop proc sp_MSlocktable
drop proc sp_MShelpmergeconflictpublications
drop proc sp_MSscriptmvastablepkc
drop proc sp_enumerrorlogs
drop proc sp_MSreinit_failed_subscriptions
drop proc sp_MSget_publication_from_taskname
drop proc sp_tableoption
drop proc sp_MSenumcolumns
drop proc sp_MSclearcolumnbit
drop proc sp_MSscriptmvastableidx
drop proc sp_add_datatype_mapping
drop proc sp_MSacquireHeadofQueueLock
drop proc sp_procoption
drop proc sp_MSsetaccesslist
drop proc sp_helpmergearticleconflicts
drop proc sp_MSscriptmvastable
drop proc sp_MSrepl_gettype_mappings
drop proc sp_pkeys
drop proc sp_MSacquireSlotLock
drop proc sp_renamedb
drop proc sp_MSreplcheck_pull
drop proc sp_helpmergeconflictrows
drop proc sp_fetchshowcmdsinput
drop proc sp_help_datatype_mapping
drop proc sp_server_info
drop proc sp_MSreleaseSlotLock
drop proc sp_remove_tempdb_file
drop proc sp_MSreplcheck_connection
drop proc sp_helpmergedeleteconflictrows
drop proc sp_replshowcmds
drop proc sp_MSfix_6x_tasks
drop proc sp_MSrepl_check_server
drop proc sp_rename
drop proc sp_MSrepl_PAL_rolecheck
drop proc sp_deletemergeconflictrow
drop proc sp_dropextendedproc
drop proc sp_article_validation
drop proc sp_MShelpconflictpublications
drop proc sp_MSreset_synctran_bit
drop proc sp_resetstatus
drop proc sp_MSreplcheck_qv
drop proc sp_getmergedeletetype
drop proc sp_addextendedproc
drop proc sp_publication_validation
drop proc sp_eventlog
drop proc sp_MSenum_replsqlqueues
drop proc sp_add_file_recover_suspect_db
drop proc sp_reinitmergepullsubscription
drop proc sp_mergedummyupdate
drop proc sp_helpextendedproc
drop proc sp_marksubscriptionvalidation
drop proc sp_replproberemoteserver
drop proc sp_special_columns
drop proc sp_MSenum_replqueues
drop proc sp_add_data_file_recover_suspect_db
drop proc sp_MSreplcheck_subscribe
drop proc sp_addtabletocontents
drop proc sp_dropanonymousagent
drop proc sp_MScleanupmergepublisher
drop proc sp_browsemergesnapshotfolder
drop proc sp_add_log_file_recover_suspect_db
drop proc sp_MSreplicationcompatlevel
drop proc sp_MSaddpubtocontents
drop proc sp_replrestart
drop proc sp_MScleanupdynsnapshotvws
drop proc sp_browsesnapshotfolder
drop proc sp_spaceused
drop proc sp_MShelp_identity_property
drop proc sp_MSget_subtypedatasrc
drop proc sp_MSpub_adjust_identity
drop proc sp_MScleanupmergepublisherdb
drop proc sp_MScopysnapshot
drop proc sp_sqlexec
drop proc sp_MSgenreplnickname
drop proc sp_addmergealternatepublisher
drop proc sp_helparticledts
drop proc sp_MShelp_replication_table
drop proc sp_sproc_columns
drop proc sp_copymergesnapshot
drop proc sp_unbindefault
drop proc sp_MSmergesubscribedb
drop proc sp_helpmergealternatepublisher
drop proc sp_changesubscriptiondtsinfo
drop proc sp_MScopyscriptfile
drop proc sp_copysnapshot
drop proc sp_unbindrule
drop proc sp_MSenumallsubscriptions
drop proc sp_dropmergealternatepublisher
drop proc sp_MSdrop_6x_replication_agent
drop proc sp_replsetoriginator
drop proc sp_MSrepl_validate_dts_package
drop proc sp_who
drop proc sp_MSenumsubscriptions
drop proc sp_MScomputemergearticlescreationorder
drop proc sp_droplogin
drop proc sp_MSreinit_article
drop proc sp_replsetoriginator_pal
drop proc sp_statistics
drop proc sp_MSget_load_hint
drop proc sp_who2
drop proc sp_MSenumallpublications
drop proc sp_MScomputemergeunresolvedrefs
drop proc sp_addsrvrolemember
drop proc sp_MScomputearticlescreationorder
drop proc sp_replincrementlsn
drop proc sp_getsubscriptiondtspackagename
drop proc sp_check_removable
drop proc sp_MSenumtranpublications
drop proc sp_MSCheckmergereplication
drop proc sp_dropsrvrolemember
drop proc sp_MScomputeunresolvedrefs
drop proc sp_replpostsyncstatus
drop proc sp_MSverifytranfilter
drop proc sp_certify_removable
drop proc sp_MSenummergepublications
drop proc sp_MSgetpubinfo
drop proc sp_grantdbaccess
drop proc sp_MShelptranconflictpublications
drop proc sp_stored_procedures
drop proc sp_repldropcolumn
drop proc sp_MSenum3rdpartypublications
drop proc sp_MSaddmergedynamicsnapshotjob
drop proc sp_addalias
drop proc sp_MShelptranconflictcounts
drop proc sp_repladdcolumn
drop proc sp_autostats
drop proc sp_MSenumthirdpartypublicationvendornames
drop proc sp_MSdropmergedynamicsnapshotjob
drop proc sp_addrole
drop proc sp_MSgettranconflictrow
drop proc sp_MSagent_access_check
drop proc sp_updatestats
drop proc sp_reinitpullsubscription
drop proc sp_MShelpmergedynamicsnapshotjob
drop proc sp_addapprole
drop proc sp_MSgettrancftsrcrow
drop proc sp_table_privileges
drop proc sp_enableagentoffload
drop proc sp_createstats
drop proc sp_addpullsubscription
drop proc sp_MSremove_userscript
drop proc sp_MSdeletetranconflictrow
drop proc sp_disableagentoffload
drop proc sp_cycle_errorlog
drop proc sp_MSupdatesharedagentproperties
drop proc sp_MSdrop_rlrecon
drop proc sp_fulltext_table
drop proc sp_MSexternalfkreferences
drop proc sp_tables
drop proc sp_getagentoffloadinfo
drop proc sp_helptrigger
drop proc sp_replicationdboption
drop proc sp_MSfetchidentityrange
drop proc sp_fulltext_column
drop proc sp_MSgetarticlereinitvalue
drop proc sp_copysubscription
drop proc sp_fixindex
drop proc sp_MSfixupdistributorinfo
drop proc sp_MScheckidentityrange
drop proc sp_helptext
drop proc sp_MSispkupdateinconflict
drop proc sp_catalogs
drop proc sp_attachsubscription
drop proc sp_settriggerorder
drop proc sp_MSfixupdistributorsecurity
drop proc sp_MShelpmergeidentity
drop proc sp_tableswc
drop proc sp_MSisnonpkukupdateinconflict
drop proc sp_tables_ex
drop proc sp_MSrestore_sub_merge
drop proc sp_MSfixupftpinfo
drop proc sp_MShelpmergearticles
drop proc sp_ivindexhasnullcols
drop proc sp_enum_oledb_providers
drop proc sp_MSrestore_sub_tran
drop proc sp_validatepropertyinputs
drop proc sp_MSfixupaltsnapshotfolder
drop proc sp_MShelpmergeschemaarticles
drop proc sp_columns_ex
drop proc sp_MSrestore_sub
drop proc sp_addextendedproperty
drop proc sp_MSfixupworkingdirectory
drop proc sp_MScreateretry
drop proc sp_replqueuemonitor
drop proc sp_prop_oledb_provider
drop proc sp_table_privileges_ex
drop proc sp_validatemergepullsubscription
drop proc sp_updateextendedproperty
drop proc sp_MSfixupuseftp
drop proc sp_MSdropretry
drop proc sp_replsqlqgetrows
drop proc sp_column_privileges_ex
drop proc sp_MSprepare_sub_for_detach
drop proc sp_dropextendedproperty
drop proc sp_MSfixupagentoffloadinfo
drop proc sp_MSdroptemptable
drop proc sp_repldeletequeuedtran
drop proc sp_indexes
drop proc sp_MSsub_check_identity
drop proc sp_addlogin
drop proc sp_MSfixupsharedagentproperties
drop proc sp_MSchangearticleresolver
drop proc sp_processmail
drop proc sp_MSpost_auto_proc
drop proc sp_foreignkeys
drop proc sp_MSsub_cleanup_orphans
drop proc sp_password
drop proc sp_addpullsubscription_agent
drop proc sp_MSenumretries
drop proc sp_MSrepl_schema
drop proc sp_primarykeys
drop proc sp_MSsub_cleanup_prop_table
drop proc sp_helpsubscription_properties
drop proc sp_MSdeleteretry
drop proc sp_fulltext_catalog
drop proc sp_MSreplupdateschema
drop proc sp_MSreseed
drop proc sp_MSaddlogin_implicit_ntlogin
drop proc sp_change_subscription_properties
drop proc sp_MSdeletepushagent
drop proc sp_change_users_login
drop proc sp_MSdefer_check
drop proc sp_MSsub_set_identity
drop proc sp_grantlogin
drop proc sp_MSget_pullsubsagent_owner
drop proc sp_MSgetonerow
drop proc sp_changedbowner
drop proc sp_MSreenable_check
drop proc sp_ddopen
drop proc sp_MSinstance_qv
drop proc sp_validatelogins
drop proc sp_droppullsubscription
drop proc sp_MSuplineageversion
drop proc sp_dboption
drop proc sp_getqueuedrows
drop proc sp_MSdrop_repltran
drop proc sp_MSget_shared_agent
drop proc sp_helppullsubscription
drop proc sp_MSgetlastrecgen
drop proc sp_MS_marksystemobject
drop proc sp_MSprep_exclusive
drop proc sp_MSdrop_pub_tables
drop proc sp_MSrepl_backup_start
drop proc sp_denylogin
drop proc sp_MStable_has_unique_index
drop proc sp_MSgetlastsentgen
drop proc sp_linkedservers_rowset
drop proc sp_verify_publication
drop proc sp_MSarticlecolstatus
drop proc sp_MSrepl_backup_complete
drop proc sp_revokelogin
drop proc sp_MSchange_retention
drop proc sp_MSgetlastsentrecgens
drop proc sp_linkedservers
drop proc sp_scriptpublicationcustomprocs
drop proc sp_MSarticlecol
drop proc sp_add_server_sortinfo
drop proc sp_MSadd_compensating_cmd
drop proc sp_MSchange_priority
drop proc sp_MSdummyupdate
drop proc sp_repltablehasnonpkuniquekey
drop proc sp_MScreate_pub_tables
drop proc sp_add_server_sortinfo75
drop proc sp_defaultdb
drop proc sp_expired_subscription_cleanup
drop proc sp_MSsetlastrecgen
drop proc sp_MSobjectprivs
drop proc sp_replscriptuniquekeywhereclause
drop proc sp_MSsetfilterparent
drop proc sp_defaultlanguage
drop proc sp_addmergepullsubscription
drop proc sp_MSsetlastsentgen
drop proc sp_getqueuedarticlesynctraninfo
drop proc sp_ActiveDirectory_Start
drop proc sp_MSdoesfilterhaveparent
drop proc sp_catalogs_rowset
drop proc sp_changemergepullsubscription
drop proc sp_MSenumgenerations
drop proc sp_ActiveDirectory_Obj
drop proc sp_getsqlqueueversion
drop proc sp_MSsetfilteredstatus
drop proc sp_MSget_setup_paths
drop proc sp_helpmergepullsubscription
drop proc sp_MScheckexistsgeneration
drop proc sp_MSdrop_rlcore
drop proc sp_MSretrieve_publication
drop proc sp_column_privileges_rowset
drop proc sp_MSremoveoffloadparameter
drop proc sp_MSadduser_implicit_ntlogin
drop proc sp_addmergepullsubscription_agent
drop proc sp_MSchecksnapshotstatus
drop proc sp_ActiveDirectory_SCP
drop proc sp_MSguidtostr
drop proc sp_MSget_current_activity
drop proc sp_MSreplsup_table_has_pk
drop proc sp_MSaddoffloadparameter
drop proc sp_MScheck_uid_owns_anything
drop proc sp_MSget_mergepullsubsagent_owner
drop proc sp_MSenumreplicas
drop proc sp_MSgetconflicttablename
drop proc sp_MSset_current_activity
drop proc sp_replsync
drop proc sp_dropmergepullsubscription
drop proc sp_MSenumdeletesmetadata
drop proc sp_MSuniqueobjectname
drop proc sp_MSobjsearch
drop proc sp_enumfullsubscribers
drop proc sp_columns_rowset
drop proc sp_MSUpgradeConflictTable
drop proc sp_adduser
drop proc sp_MSreplraiserror
drop proc sp_MSenumpartialdeletes
drop proc sp_MSSetServerProperties
drop proc sp_MSuniquetempname
drop proc sp_MShasdbaccess
drop proc sp_addpublication
drop proc sp_MSsendtosqlqueue
drop proc sp_revokedbaccess
drop proc sp_check_sync_trigger
drop proc sp_MSenumchanges
drop proc sp_MSsetalertinfo
drop proc sp_MSuniquecolname
drop proc sp_resolve_logins
drop proc sp_changepublication
drop proc sp_check_constraints_rowset
drop proc sp_adjustpublisheridentityrange
drop proc sp_dropuser
drop proc sp_check_for_sync_trigger
drop proc sp_MSenumpartialchanges
drop proc sp_MSaddguidcolumn
drop proc sp_MShelpcolumns
drop proc sp_changesubscription
drop proc sp_MSestimatemergesnapshotworkload
drop proc sp_MSpad_command
drop proc sp_MSinitdynamicsubscriber
drop proc sp_MSprepare_mergearticle
drop proc sp_MShelpindex
drop proc sp_helparticle
drop proc sp_check_constbytable_rowset
drop proc sp_MSestimatesnapshotworkload
drop proc sp_dropalias
drop proc sp_MSflush_command
drop proc sp_MSgetrowmetadata
drop proc sp_MSgetcolumnlist
drop proc sp_MShelptype
drop proc sp_MSis_col_replicated
drop proc sp_MSget_colinfo
drop proc sp_MSgetmetadatabatch
drop proc sp_MSaddguidindex
drop proc sp_MSdependencies
drop proc sp_articlecolumn
drop proc sp_foreign_keys_rowset
drop proc sp_MSdropfkreferencingarticle
drop proc sp_addgroup
drop proc sp_MSget_col_position
drop proc sp_MSsetrowmetadata
drop proc sp_MSrefcnt
drop proc sp_MStablespace
drop proc sp_helparticlecolumns
drop proc sp_addscriptexec
drop proc sp_droprole
drop proc sp_MSget_map_position
drop proc sp_MSinsertgenhistory
drop proc sp_MSgentablenickname
drop proc sp_MSindexspace
drop proc sp_helppublication
drop proc sp_MSmergeupdatelastsyncinfo
drop proc sp_dropgroup
drop proc sp_MSget_type
drop proc sp_MSupdategenhistory
drop proc sp_MStablenickname
drop proc sp_MStablerefs
drop proc sp_helpsubscription
drop proc sp_indexes_rowset
drop proc sp_MSrepl_FixPALRole
drop proc sp_MSscript_where_clause
drop proc sp_MSlocalizeinterruptedgenerations
drop proc sp_MStablenamefromnick
drop proc sp_MStablekeys
drop proc sp_articlefilter
drop proc sp_createmergepalrole
drop proc sp_approlepassword
drop proc sp_MSscript_params
drop proc sp_MSenumschemachange
drop proc sp_MSgetmakegenerationapplock
drop proc sp_MStablechecks
drop proc sp_MSscript_article_view
drop proc sp_primary_keys_rowset
drop proc sp_MSsetcontext_replagent
drop proc sp_setapprole
drop proc sp_MSscript_procbodystart
drop proc sp_MSenumschemachange_70
drop proc sp_MSreleasemakegenerationapplock
drop proc sp_MSsettopology
drop proc sp_articleview
drop proc sp_dropapprole
drop proc sp_MSscript_begintrig1
drop proc sp_MSenumschemachange_80
drop proc sp_user_counter1
drop proc sp_MSmakegeneration
drop proc sp_MSmatchkey
drop proc sp_MSaddexecarticle
drop proc sp_provider_types_rowset
drop proc sp_MSdrop_replcom
drop proc sp_addrolemember
drop proc sp_MSscript_begintrig2
drop proc sp_MSenumschemachange_80sp3
drop proc sp_user_counter2
drop proc sp_MSfixlineageversions
drop proc sp_MSforeach_worker
drop proc sp_MSaddschemaarticle
drop proc sp_MScreate_distributor_tables
drop proc sp_droprolemember
drop proc sp_MSscript_endtrig
drop proc sp_MSupdateschemachange
drop proc sp_user_counter3
drop proc sp_MSaddupdatetrigger
drop proc sp_MSforeachdb
drop proc sp_addarticle
drop proc sp_changegroup
drop proc sp_MSscript_trigger_variables
drop proc sp_MSremove_mergereplcommand
drop proc sp_user_counter4
drop proc sp_MSaddmergetriggers
drop proc sp_MSforeachtable
drop proc sp_MSgettranconflictname
drop proc sp_procedure_params_rowset
drop proc sp_MSIfExistsRemoteLogin
drop proc sp_MSscript_trigger_assignment
drop proc sp_MSadd_mergereplcommand
drop proc sp_user_counter5
drop proc sp_MSchangeobjectowner
drop proc sp_MSloginmappings
drop proc sp_MSmaketrancftproc
drop proc sp_helppublicationsync
drop proc sp_MSscript_trigger_fetch_statement
drop proc sp_MSsetreplicainfo
drop proc sp_user_counter6
drop proc sp_MShelpdestowner
drop proc sp_MScleanuptask
drop proc sp_MSuniquename
drop proc sp_changesubstatus
drop proc sp_MSreplrole
drop proc sp_check_removable_sysusers
drop proc sp_MSscript_trigger_exec_rpc
drop proc sp_MSsetreplicastatus
drop proc sp_user_counter7
drop proc sp_MSfillupmissingcols
drop proc sp_MSkilldb
drop proc sp_addsubscription
drop proc sp_procedures_rowset
drop proc sp_addpublication_snapshot
drop proc sp_changeobjectowner
drop proc sp_MSscript_trigger_update_checks
drop proc sp_MScreateglobalreplica
drop proc sp_user_counter8
drop proc sp_MSmaptype
drop proc sp_MSchangeschemaarticle
drop proc sp_MShelpobjectpublications
drop proc sp_helpsrvrole
drop proc sp_MSscript_trigger_updates
drop proc sp_MSsetconflictscript
drop proc sp_user_counter9
drop proc sp_MSquerysubtype
drop proc sp_MSSQLDMO80_version
drop proc sp_changearticle
drop proc sp_schemata_rowset
drop proc sp_helpreplicationdb
drop proc sp_srvrolepermission
drop proc sp_MSscript_trigger_version_updates
drop proc sp_MSsetconflicttable
drop proc sp_user_counter10
drop proc sp_showrowreplicainfo
drop proc sp_MSSQLDMO70_version
drop proc sp_droparticle
drop proc sp_helpdistributor
drop proc sp_helpsrvrolemember
drop proc sp_MSscript_singlerow_trigger
drop proc sp_MSmakeconflictinsertproc
drop proc sp_blockcnt
drop proc sp_MSsethighestversion
drop proc sp_MSSQLOLE65_version
drop proc sp_droppublication
drop proc sp_statistics_rowset
drop proc sp_enumdsn
drop proc sp_helpdbfixedrole
drop proc sp_MSscript_multirow_trigger
drop proc sp_MSmaketempinsertproc
drop proc sp_tempdbspace
drop proc sp_mergemetadataretentioncleanup
drop proc sp_MSSQLOLE_version
drop proc sp_dropsubscription
drop proc sp_enumoledbdatasources
drop proc sp_dbfixedrolepermission
drop proc sp_MSscript_sync_ins_trig
drop proc sp_MSgetconflictinsertproc
drop proc sp_MSpurgecontentsorphans
drop proc sp_MSscriptdatabase
drop proc sp_subscribe
drop proc sp_tables_rowset
drop proc sp_helpsubscriberinfo
drop proc sp_helprolemember
drop proc sp_MSscript_sync_upd_trig
drop proc sp_MSinsertdeleteconflict
drop proc sp_dbcmptlevel
drop proc sp_MScleanup_zeroartnick_genhistory
drop proc sp_MSscriptdb_worker
drop proc sp_unsubscribe
drop proc sp_replica
drop proc sp_helprole
drop proc sp_MSscript_sync_del_trig
drop proc sp_MScheckmetadatamatch
drop proc sp_fallback_MS_sel_fb_svr
drop proc sp_execresultset
drop proc sp_MSdelete_specifiedcontents
drop proc sp_MSdbuseraccess
drop proc sp_refreshsubscriptions
drop proc sp_addpublisher
drop proc sp_helpntgroup
drop proc sp_MSget_synctran_column
drop proc sp_MSdelrow
drop proc sp_validname
drop proc sp_MSispulldistributionjobnamegenerated
drop proc sp_MSdrop_rladmin
drop proc sp_MSdbuserpriv
drop proc sp_MSpublishdb
drop proc sp_tables_info_rowset
drop proc sp_addsubscriber
drop proc sp_addqueued_artinfo
drop proc sp_MSsetartprocs
drop proc sp_validlang
drop proc sp_MSispullmergejobnamegenerated
drop proc sp_MSaddmergepub_snapshot
drop proc sp_MShelpfulltextindex
drop proc sp_MSactivate_auto_sub
drop proc sp_addsubscriber_schedule
drop proc sp_addlinkedserver
drop proc sp_addsynctriggers
drop proc sp_MSmakesystableviews
drop proc sp_addmessage
drop proc sp_MSdropmergepub_snapshot
drop proc sp_MShelpfulltextscript
drop proc sp_MSget_synctran_commands
drop proc sp_table_constraints_rowset
drop proc sp_changesubscriber
drop proc sp_dropserver
drop proc sp_setreplfailovermode
drop proc sp_MSgetchangecount
drop proc sp_addumpdevice
drop proc sp_MScheckatpublisher
drop proc sp_script_synctran_commands
drop proc sp_changesubscriber_schedule
drop proc sp_serveroption
drop proc sp_helpreplfailovermode
drop proc sp_MSbelongs
drop proc sp_addremotelogin
drop proc sp_MSaddmergeschemaarticle
drop proc sp_MSGetServerProperties
drop proc sp_MSaddpub_snapshot
drop proc sp_table_privileges_rowset
drop proc sp_distcounters
drop proc sp_addserver
drop proc sp_helpreplicationdboption
drop proc sp_MSexpandbelongs
drop proc sp_addtype
drop proc sp_addmergearticle
drop proc sp_MSis_pk_col
drop proc sp_droppublisher
drop proc sp_setnetname
drop proc sp_MScheck_agent_instance
drop proc sp_MSexpandnotbelongs
drop proc sp_altermessage
drop proc sp_MSchangemergeschemaarticle
drop proc sp_MSSharedFixedDisk
drop proc sp_MSmark_proc_norepl
drop proc sp_table_statistics_rowset
drop proc sp_dropsubscriber
drop proc sp_helpserver
drop proc sp_MSBumpupCompLevel
drop proc sp_MSsetupbelongs_withoutviewproc
drop proc sp_attach_db
drop proc sp_changemergearticle
drop proc sp_MSfilterclause
drop proc sp_MSdrop_expired_subscription
drop proc sp_dsninfo
drop proc sp_helplinkedsrvlogin
drop proc sp_MSCleanupForPullReinit
drop proc sp_MSsetupnotbelongs
drop proc sp_attach_single_file_db
drop proc sp_MSadjustmergeidentity
drop proc sp_MSgetalertinfo
drop proc sp_MSscript_validate_subscription
drop proc sp_publishdb
drop proc sp_addlinkedsrvlogin
drop proc sp_MSpublicationcleanup
drop proc sp_MSsetupworktables
drop proc sp_helplanguage
drop proc sp_helpallowmerge_publication
drop proc sp_MSvalidate_subscription
drop proc sp_oledb_column_constraints
drop proc sp_MScreate_dist_tables
drop proc sp_droplinkedsrvlogin
drop proc sp_cleanupdbreplication
drop proc sp_MSsetupbelongs
drop proc sp_bindefault
drop proc sp_MSdroparticleconstraints
drop proc sp_helpmergearticle
drop proc sp_MSscript_insert_statement
drop proc sp_MSupdate_mqserver_distdb
drop proc sp_MSarticlecleanup
drop proc sp_MSaddinitialarticle
drop proc sp_bindrule
drop proc sp_MSacquireserverresourcefordynamicsnapshot
drop proc sp_dropmergearticle
drop proc sp_script_insertforcftresolution
drop proc sp_oledb_indexinfo
drop proc sp_MSadd_distributor_alerts_and_responses
drop proc sp_fulltext_service
drop proc sp_MSdroparticleprocs
drop proc sp_MSaddinitialschemaarticle
drop proc sp_checknames
drop proc sp_addmergepublication
drop proc sp_MSscript_insert_subwins
drop proc sp_oledb_ro_usrname
drop proc sp_MSdrop_distributor_alerts_and_responses
drop proc sp_fulltext_database
drop proc sp_MSdroparticletriggers
drop proc sp_MSaddinitialpublication
drop proc sp_configure
drop proc sp_changemergepublication
drop proc sp_MSis_identity_insert
drop proc sp_oledb_deflang
drop proc sp_adddistributor
drop proc sp_mergesubscription_cleanup
drop proc sp_MSaddinitialsubscription
drop proc sp_dbremove
drop proc sp_helpmergepublication
drop proc sp_MSscript_compensating_send
drop proc sp_oledb_defdb
drop proc sp_changedistributor_property
drop proc sp_subscription_cleanup
drop proc sp_MSmakearticleprocs
drop proc sp_create_removable
drop proc sp_MSgettranlastupdatedtime
drop proc sp_dropmergepublication
drop proc sp_MSscriptinsertconflictfinder
drop proc sp_oledb_database
drop proc sp_helpdistributor_properties
drop proc sp_get_distributor
drop proc sp_MSupdatesysmergearticles
drop proc sp_depends
drop proc sp_MSgetmergelastupdatedtime
drop proc sp_mergearticlecolumn
drop proc sp_MSscript_insert_pubwins
drop proc sp_oledb_language
drop proc sp_dropdistributor
drop proc sp_help_fulltext_catalogs
drop proc sp_MSrepl_addrolemember
drop proc sp_MSexclause
drop proc sp_detach_db
drop proc sp_MSgetlastupdatedtime
drop proc sp_helpmergearticlecolumn
drop proc sp_MSscript_update_statement
drop proc sp_tablecollations
drop proc sp_helpdistributiondb
drop proc sp_help_fulltext_catalogs_cursor
drop proc sp_MSrepl_droprolemember
drop proc sp_MSgetcolordinalfromcolname
drop proc sp_diskdefault
drop proc sp_MSreinitmergepublication
drop proc sp_scriptpubwinsrefreshcursorvars
drop proc sp_bcp_dbcmptlevel
drop proc sp_changedistributiondb
drop proc sp_help_fulltext_tables
drop proc sp_table_validation
drop proc sp_MSinsertbeforeimageclause
drop proc sp_dropdevice
drop proc sp_MSreinit_hub
drop proc sp_MSscript_update_subwins
drop proc sp_dropdistributiondb
drop proc sp_help_fulltext_tables_cursor
drop proc sp_removedbreplication
drop proc sp_MScreatedupkeyupdatequery
drop proc sp_dropmessage
drop proc sp_reinitmergesubscription
drop proc sp_MSscriptupdateconflictfinder
drop proc sp_adddistributiondb
drop proc sp_help_fulltext_columns
drop proc sp_removesrvreplication
drop proc sp_MSmakeinsertproc
drop proc sp_droptype
drop proc sp_MSpublicationview
drop proc sp_MSscript_update_pubwins
drop proc sp_dropdistpublisher
drop proc sp_help_fulltext_columns_cursor
drop proc sp_MSremovedbreplication
drop proc sp_MSmakeupdateproc
drop proc sp_dropremotelogin
drop proc sp_addmergesubscription
drop proc sp_MSscript_delete_statement
drop proc sp_adddistpublisher
drop proc sp_trace_getdata
drop proc sp_vupgrade_subscription_databases
drop proc sp_MSmakeselectproc
drop proc sp_helpconstraint
drop proc sp_MSretrieve_mergepublication
drop proc sp_MSscript_delete_subwins
drop proc sp_changedistpublisher
drop proc sp_describe_cursor
drop proc sp_MScopyregvalue
drop proc sp_MSdropconstraints
drop proc sp_changemergesubscription
drop proc sp_MSscriptdelconflictfinder
drop proc sp_helpdistpublisher
drop proc sp_describe_cursor_columns
drop proc sp_vupgrade_registry
drop proc sp_makewebtask
drop proc sp_MSinsertschemachange
drop proc sp_MSreplcheckoffloadserver
drop proc sp_helpmergesubscription
drop proc sp_MSscript_compensating_insert
drop proc sp_add_agent_profile
drop proc sp_describe_cursor_tables
drop proc sp_vupgrade_subscription_tables
drop proc sp_dropwebtask
drop proc sp_MSgetviewcolumnlist
drop proc sp_dropmergesubscription
drop proc sp_MSscript_delete_pubwins
drop proc sp_drop_agent_parameter
drop proc sp_cursor_list
drop proc sp_vupgrade_mergetables
drop proc sp_runwebtask
drop proc sp_MSvalidatearticle
drop proc sp_MSget_file_existence
drop proc sp_MShelpvalidationdate
drop proc sp_MSscript_beginproc
drop proc sp_drop_agent_profile
drop proc sp_vupgrade_subpass
drop proc sp_cleanupwebtask
drop proc sp_MSsubscriptionvalidated
drop proc sp_MSrepl_isdbowner
drop proc sp_MSmergepublishdb
drop proc sp_MSscript_security
drop proc sp_help_agent_profile
drop proc sp_vupgrade_MSsubscription_properties
drop proc sp_enumcodepages
drop proc sp_MSdroparticletombstones
drop proc sp_resyncmergesubscription
drop proc sp_enumcustomresolvers
drop proc sp_MSscript_endproc
drop proc sp_help_agent_default
drop proc sp_vupgrade_replication
drop proc sp_convertwebtasks
drop proc sp_MSproxiedmetadata
drop proc sp_MSget_qualified_name
drop proc sp_changemergefilter
drop proc sp_MStable_not_modifiable
drop proc sp_MSupdate_agenttype_default
drop proc sp_vupgrade_distdb
drop proc sp_readwebtask
drop proc sp_MScontractsubsnb
drop proc sp_MSdrop_object
drop proc sp_addmergefilter
drop proc sp_MSscript_ExecutionMode_stmt
drop proc sp_generate_agent_parameter
drop proc sp_vupgrade_publisher
drop proc sp_MSexpandsubsnb
drop proc sp_isarticlecolbitset
drop proc sp_dropmergefilter
drop proc sp_MSscript_sync_ins_proc
drop proc sp_MSvalidate_agent_parameter
drop proc sp_vupgrade_syscol_status
drop proc sp_MSdelsubrows
drop proc sp_helpdb
drop proc sp_getarticlepkcolbitmap
drop proc sp_helpmergefilter
drop proc sp_MSscript_sync_upd_proc
drop proc sp_add_agent_parameter
drop proc sp_vupgrade_publisherdb
drop proc sp_MSdelsubrowsbatch
drop proc sp_helpdevice
drop proc sp_MSsubst_filter_name
drop proc sp_MSscript_dri
drop proc sp_MSscript_sync_del_proc
drop proc sp_change_agent_parameter
drop proc sp_vupgrade_replmsdb
drop proc sp_MSscriptviewproc
drop proc sp_helpfile
drop proc sp_MSsubst_filter_names
drop proc sp_MSenumpubreferences
drop proc sp_MSscript_pub_upd_trig
drop proc sp_change_agent_profile
drop proc sp_restoredbreplication
drop proc sp_MSmakeviewproc
drop proc sp_helpfilegroup
drop proc sp_MSreplcheck_name
drop proc sp_MSsubsetpublication
drop proc sp_MSmakeconflicttable
drop proc sp_help_agent_parameter
drop proc sp_MSget_publisher_rpc
drop proc sp_MScreatebeforetable
drop proc sp_helpgroup
drop proc sp_MScheckvalidsystables
drop proc sp_MSindexcolfrombin
drop proc sp_scriptsubconflicttable
drop proc sp_MShelp_distdb
drop proc sp_link_publication
drop proc sp_MShelpcreatebeforetable
drop proc sp_helplog
drop proc sp_MSdrop_mergesystables
drop proc sp_MSmakejoinfilter
drop proc sp_MSgen_sync_tran_procs
drop proc sp_MSupdate_replication_status
drop proc sp_MSreset_queue
drop proc sp_MShelpalterbeforetable
drop proc sp_helplogins
drop proc sp_MScreate_mergesystables
drop proc sp_MSmakeexpandproc
drop proc sp_articlesynctranprocs
drop proc sp_MSenum_misc_agents
drop proc sp_MSreset_queued_reinit
drop proc sp_MSgetbeforetableinsert
drop proc sp_helpindex
drop proc sp_MStestbit
drop proc sp_MSdrop_expired_mergesubscription
drop proc sp_reinitsubscription
drop proc sp_MSload_replication_status
drop proc sp_MSinit_subscription_agent
drop proc sp_MSfixupbeforeimagetables
drop proc sp_helpstats
drop proc sp_MSsetbit
drop proc sp_MScleanup_metadata
drop proc sp_msupg_removesystemcomputedcolumns
drop proc sp_MSareallcolumnscomputed
drop proc sp_MScreate_replication_status_table
drop proc sp_MSupdatelastsyncinfo
drop proc sp_MSreplcheck_permission
drop proc sp_objectfilegroup
drop proc sp_MSinsertcontents
drop proc sp_helpmergecleanupwait
drop proc sp_MSgettypestringudt
drop proc sp_MShelp_replication_status
drop proc sp_MSget_attach_state
drop proc sp_MSinserterrorlineage
drop proc sp_help
drop proc sp_MSupdatecontents
drop proc sp_MSquiescecheck
drop proc sp_gettypestring
drop proc sp_MSenum_replication_agents
drop proc sp_MSreset_attach_state
drop proc sp_MSevalsubscriberinfo
drop proc sp_helprotect
drop proc sp_MSdeletecontents
drop proc sp_mergepreparecleanup
drop proc sp_scriptpkwhereclause
drop proc sp_replication_agent_checkup
drop proc sp_column_privileges
drop proc sp_MSset_subscription_properties
drop proc sp_MSsetsubscriberinfo
drop proc sp_MSunmarkifneeded
drop proc sp_MSpreparecleanup
drop proc sp_MSscript_missing_row_check
drop proc sp_MScreate_replication_checkup_agent
drop proc sp_MSset_sub_guid
drop proc sp_MSgetsubscriberinfo
drop proc sp_helpuser
drop proc sp_MSunmarkreplinfo
drop proc sp_MSquiescetriggerson
drop proc sp_msupg_recreatecatalogfaketables
drop proc sp_scriptupdateparams
drop proc sp_MSenum_replication_job
drop proc sp_populateqtraninfo
drop proc sp_MSmakectsview
drop proc sp_indexoption
drop proc sp_MSmarkreplinfo
drop proc sp_MSquiescetriggersoff
drop proc sp_msupg_dosystabcatalogupgrades
drop proc sp_scriptreconwhereclause
drop proc sp_MSrepl_dbrole
drop proc sp_MScreate_sub_tables
drop proc sp_MSinsertgenerationschemachanges
drop proc sp_lock
drop proc sp_MSunmarkschemaobject
drop proc sp_MSquiesceforcleanup
drop proc sp_msupg_dropcatalogcomputedcols
drop proc sp_script_reconciliation_insproc
drop proc sp_changedistributor_password
drop proc sp_columns
drop proc sp_MSupdate_mqserver_subdb
drop proc sp_MSalreadyhavegeneration
drop proc sp_getapplock
drop proc sp_MSmarkschemaobject
drop proc sp_mergecompletecleanup
drop proc sp_msupg_createcatalogcomputedcols
drop proc sp_script_reconciliation_delproc
drop proc sp_oledbinfo
drop proc sp_MS_replication_installed
drop proc sp_MSgettablecontents
drop proc sp_releaseapplock
drop proc sp_MSaddanonymousreplica
drop proc sp_MScompletecleanup
drop proc sp_msupg_recreatesystemviews
drop proc sp_script_reconciliation_xdelproc
drop proc sp_MSget_oledbinfo
drop proc sp_databases
drop proc sp_MSunc_to_drive
drop proc sp_MSdelgenzero
drop proc sp_logdevice
drop proc sp_MSgetreplicainfo
drop proc sp_MSpropagateschematorepubs
drop proc sp_msupg_upgradecatalog
drop proc sp_scriptinsproc
drop proc sp_grant_publication_access
drop proc sp_MSretrieve_publication_attributes
drop proc sp_MSmakedynsnapshotvws
drop proc sp_helpremotelogin
drop proc sp_MSadd_repl_job
drop proc sp_mergecleanupmetadata
drop proc sp_scriptdelproc
drop proc sp_revoke_publication_access
drop proc sp_MScleanup_publication_ADinfo
drop proc sp_MSdropdynsnapshotvws
drop proc sp_helpsort
drop proc sp_MScheck_subscription
drop proc sp_MScleanup_conflict_table
drop proc sp_scriptxdelproc
drop proc sp_help_publication_access
drop proc sp_MSrepl_linkedservers_rowset
March 8, 2006 at 4:47 pm
Are you running this in the published/formerly database? You should get something like this. These are only related to replication.
-------------------------------------------------------------------------------------------------------------------------------------------
drop table conflict_EFile_Merge_EfilePayment
drop table conflict_EFile_Merge_DocumentActivity
drop table conflict_EFile_Merge_WIPXML
drop table conflict_EFile_Merge_MQQueue
drop table conflict_EFile_Merge_TempPDFDocuments
drop table conflict_EFile_Merge_JUDCase
drop table conflict_EFile_Merge_InvalidCase
drop table conflict_EFile_Merge_FeeWaived
drop table conflict_EFile_Merge_CaseTransferHistory
drop table conflict_EFile_Merge_Document
drop table conflict_EFile_Merge_DocMultiType
drop table conflict_EFile_Merge_Notice
drop table conflict_EFile_Merge_Orders
drop table conflict_EFile_Merge_Motion
drop table conflict_EFile_Merge_DocParty
drop table conflict_EFile_Merge_SealedActivity
drop table conflict_EFile_Merge_Rulings
drop table conflict_EFile_Merge_OrdersByMotion
drop table conflict_EFile_Merge_PDFDocuments
drop table conflict_EFile_Merge_EntryNumber
drop table conflict_EFile_Merge_XMLTemplate
drop table conflict_EFile_Merge_RVACCT
drop table conflict_EFile_Merge_ReceiptNumAssign
drop table conflict_EFile_Merge_PARTY
drop table conflict_EFile_Merge_JDEZ_CALENDAR
drop table conflict_EFile_Merge_ErrorLog
drop table MSmerge_delete_conflicts
drop table conflict_EFile_Merge_EntryNumberHistory
drop table conflict_EFile_Merge_EFileEMailLog
drop table conflict_EFile_Merge_COMPANION_CASE
drop table conflict_EFile_Merge_CIVIL_RESACT
drop table conflict_EFile_Merge_CIVIL_CASE
drop table conflict_EFile_Merge_CaseNumAssign
drop table conflict_EFile_Merge_CASE_HISTORY
drop table conflict_EFile_Merge_CASE_CONTROL
drop table conflict_EFile_Merge_Bar_Master
drop table conflict_EFile_Merge_APPEARANCE_REPRESENTATION
drop table conflict_EFile_Merge_PDF_Backup
drop table conflict_EFile_Merge_AuditLog
drop table conflict_EFile_Merge_NotesHistory
drop table conflict_EFile_Merge_AuditHistory
drop table conflict_EFile_Merge_ProcessStatus
(42 row(s) affected)
---------------------------------------------------------------------------------------------------------------------------------------------
drop trigger ins_8CCE4DE24BB242A7B10CF5039FC7671B
drop trigger upd_8CCE4DE24BB242A7B10CF5039FC7671B
drop trigger del_8CCE4DE24BB242A7B10CF5039FC7671B
drop trigger ins_A1A87C0FB71D4B04BBCA57526DBE88AE
drop trigger upd_A1A87C0FB71D4B04BBCA57526DBE88AE
drop trigger del_A1A87C0FB71D4B04BBCA57526DBE88AE
drop trigger ins_38F543CC00EE4209858E632255B2C94C
drop trigger upd_38F543CC00EE4209858E632255B2C94C
drop trigger del_38F543CC00EE4209858E632255B2C94C
drop trigger ins_C9CF021DDD834721A8C96B366C3B7425
drop trigger upd_C9CF021DDD834721A8C96B366C3B7425
drop trigger del_C9CF021DDD834721A8C96B366C3B7425
drop trigger ins_72989293CA5141F0AC8AA1B5BD45E48A
drop trigger upd_72989293CA5141F0AC8AA1B5BD45E48A
drop trigger del_72989293CA5141F0AC8AA1B5BD45E48A
drop trigger ins_749877420DC34B92BF75AE6947A81F4E
drop trigger upd_749877420DC34B92BF75AE6947A81F4E
drop trigger del_749877420DC34B92BF75AE6947A81F4E
drop trigger ins_8B4B6E7A29914AF7A1D2BF672F23B59B
drop trigger upd_8B4B6E7A29914AF7A1D2BF672F23B59B
drop trigger del_8B4B6E7A29914AF7A1D2BF672F23B59B
drop trigger ins_FB3B992735854DDE886CA78DF508C543
drop trigger upd_FB3B992735854DDE886CA78DF508C543
drop trigger del_FB3B992735854DDE886CA78DF508C543
drop trigger ins_0F36ADC0CB29498597CF0B4069878C79
drop trigger upd_0F36ADC0CB29498597CF0B4069878C79
drop trigger del_0F36ADC0CB29498597CF0B4069878C79
drop trigger ins_3FF08AC3D7E441809441539521803651
drop trigger upd_3FF08AC3D7E441809441539521803651
drop trigger del_3FF08AC3D7E441809441539521803651
drop trigger ins_D2AF7B154DEB4255821624319169F129
drop trigger upd_D2AF7B154DEB4255821624319169F129
drop trigger del_D2AF7B154DEB4255821624319169F129
drop trigger ins_D7949F529EA34D4BACC9DE601186C0EB
drop trigger upd_D7949F529EA34D4BACC9DE601186C0EB
drop trigger del_D7949F529EA34D4BACC9DE601186C0EB
drop trigger ins_61C94C92DB024F7F82B53C36B832F326
drop trigger upd_61C94C92DB024F7F82B53C36B832F326
drop trigger del_61C94C92DB024F7F82B53C36B832F326
drop trigger ins_059A7C4F47E24A51B72F8F81D3F90C2B
drop trigger upd_059A7C4F47E24A51B72F8F81D3F90C2B
drop trigger del_059A7C4F47E24A51B72F8F81D3F90C2B
drop trigger ins_A30B9421B5EC45AF820BD70DFF4D0473
drop trigger upd_A30B9421B5EC45AF820BD70DFF4D0473
drop trigger del_A30B9421B5EC45AF820BD70DFF4D0473
drop trigger ins_921BEE785EDA4539BEC231CA6758EB98
drop trigger upd_921BEE785EDA4539BEC231CA6758EB98
drop trigger del_921BEE785EDA4539BEC231CA6758EB98
drop trigger ins_3396E764DEE44C21A90B74B3DB271713
drop trigger upd_3396E764DEE44C21A90B74B3DB271713
drop trigger del_3396E764DEE44C21A90B74B3DB271713
drop trigger ins_C9E6B7898760458EB82FECC672675824
drop trigger upd_C9E6B7898760458EB82FECC672675824
drop trigger del_C9E6B7898760458EB82FECC672675824
drop trigger ins_82A7978C48E9483C8CF745C92979B4BF
drop trigger upd_82A7978C48E9483C8CF745C92979B4BF
drop trigger del_82A7978C48E9483C8CF745C92979B4BF
drop trigger ins_A12CF699787F4FD2A0E96A841F842693
drop trigger upd_A12CF699787F4FD2A0E96A841F842693
drop trigger del_A12CF699787F4FD2A0E96A841F842693
drop trigger ins_729123C2C5354EF1B7E3CE4E295DD60C
drop trigger upd_729123C2C5354EF1B7E3CE4E295DD60C
drop trigger del_729123C2C5354EF1B7E3CE4E295DD60C
drop trigger ins_95E2390573A84D16BAFECB7734DDA2C7
drop trigger upd_95E2390573A84D16BAFECB7734DDA2C7
drop trigger del_95E2390573A84D16BAFECB7734DDA2C7
drop trigger ins_4E3D899E672844FF86DEAD23578167A3
drop trigger upd_4E3D899E672844FF86DEAD23578167A3
drop trigger del_4E3D899E672844FF86DEAD23578167A3
drop trigger ins_316B988DBB2841FA9498B5A070715306
drop trigger upd_316B988DBB2841FA9498B5A070715306
drop trigger del_316B988DBB2841FA9498B5A070715306
drop trigger ins_4E5E01826A0D4F66BD0359B47A5B1501
drop trigger upd_4E5E01826A0D4F66BD0359B47A5B1501
drop trigger del_4E5E01826A0D4F66BD0359B47A5B1501
drop trigger ins_731CD2C246C34B4883540C85DE393CE4
drop trigger upd_731CD2C246C34B4883540C85DE393CE4
drop trigger del_731CD2C246C34B4883540C85DE393CE4
drop trigger ins_A65A2CCEA4C5407EB1270E655A0C79F9
drop trigger upd_A65A2CCEA4C5407EB1270E655A0C79F9
drop trigger del_A65A2CCEA4C5407EB1270E655A0C79F9
drop trigger ins_5E09CA24B0C049999C2F15756307960E
drop trigger upd_5E09CA24B0C049999C2F15756307960E
drop trigger del_5E09CA24B0C049999C2F15756307960E
drop trigger ins_F67721140C51497F9EF3155E58251B0F
drop trigger upd_F67721140C51497F9EF3155E58251B0F
drop trigger del_F67721140C51497F9EF3155E58251B0F
drop trigger ins_44C3CFBC5855442F883E7A113286C3C3
drop trigger upd_44C3CFBC5855442F883E7A113286C3C3
drop trigger del_44C3CFBC5855442F883E7A113286C3C3
drop trigger ins_5E8D09F582B845E1BED7ACB6DD04BCD6
drop trigger upd_5E8D09F582B845E1BED7ACB6DD04BCD6
drop trigger del_5E8D09F582B845E1BED7ACB6DD04BCD6
drop trigger ins_D668822B5BB04B34A3DFF296705A0241
drop trigger upd_D668822B5BB04B34A3DFF296705A0241
drop trigger del_D668822B5BB04B34A3DFF296705A0241
drop trigger ins_CD61955AF2B343D0835699CDD1670B5A
drop trigger upd_CD61955AF2B343D0835699CDD1670B5A
drop trigger del_CD61955AF2B343D0835699CDD1670B5A
drop trigger ins_CD5CE7B008C84888AD851B4098026316
drop trigger upd_CD5CE7B008C84888AD851B4098026316
drop trigger del_CD5CE7B008C84888AD851B4098026316
drop trigger ins_A19C5A2493074A9C9965AD3C90574C34
drop trigger upd_A19C5A2493074A9C9965AD3C90574C34
drop trigger del_A19C5A2493074A9C9965AD3C90574C34
drop trigger ins_C172FF6E4C0E4BABB68E8AD3C3805B2F
drop trigger upd_C172FF6E4C0E4BABB68E8AD3C3805B2F
drop trigger del_C172FF6E4C0E4BABB68E8AD3C3805B2F
drop trigger ins_9A6161E4E762498381F1582822596223
drop trigger upd_9A6161E4E762498381F1582822596223
drop trigger del_9A6161E4E762498381F1582822596223
drop trigger ins_7A691DF5285B449686550669B69FFC86
drop trigger upd_7A691DF5285B449686550669B69FFC86
drop trigger del_7A691DF5285B449686550669B69FFC86
drop trigger ins_AD73B61E18DB4A04BD509111A5EFA29B
drop trigger upd_AD73B61E18DB4A04BD509111A5EFA29B
drop trigger del_AD73B61E18DB4A04BD509111A5EFA29B
drop trigger ins_3A22986CDFDC4A38AD8C507D6EBE0837
drop trigger upd_3A22986CDFDC4A38AD8C507D6EBE0837
drop trigger del_3A22986CDFDC4A38AD8C507D6EBE0837
drop trigger ins_DADD052666354C2B9FB29E162FB0A6D9
drop trigger upd_DADD052666354C2B9FB29E162FB0A6D9
drop trigger del_DADD052666354C2B9FB29E162FB0A6D9
(123 row(s) affected)
------------------------------------------------------------------------------------------------------------------------------------------
drop proc sp_cft_F67721140C51497FD559C54F92D74422
drop proc sp_cft_72989293CA5141F0D559C54F92D74422
drop proc sp_ins_44C3CFBC5855442FD559C54F92D74422
drop proc sp_upd_44C3CFBC5855442FD559C54F92D74422
drop proc sp_ins_749877420DC34B92D559C54F92D74422
drop proc sp_sel_44C3CFBC5855442FD559C54F92D74422
drop proc sp_upd_749877420DC34B92D559C54F92D74422
drop proc sp_sel_749877420DC34B92D559C54F92D74422
drop proc sp_cft_44C3CFBC5855442FD559C54F92D74422
drop proc sp_cft_749877420DC34B92D559C54F92D74422
drop proc sp_ins_5E8D09F582B845E1D559C54F92D74422
drop proc sp_upd_5E8D09F582B845E1D559C54F92D74422
drop proc sp_ins_8B4B6E7A29914AF7D559C54F92D74422
drop proc sp_sel_5E8D09F582B845E1D559C54F92D74422
drop proc sp_upd_8B4B6E7A29914AF7D559C54F92D74422
drop proc sp_sel_8B4B6E7A29914AF7D559C54F92D74422
drop proc sp_cft_5E8D09F582B845E1D559C54F92D74422
drop proc sp_cft_8B4B6E7A29914AF7D559C54F92D74422
drop proc sp_ins_D668822B5BB04B34D559C54F92D74422
drop proc sp_upd_D668822B5BB04B34D559C54F92D74422
drop proc sp_ins_FB3B992735854DDED559C54F92D74422
drop proc sp_sel_D668822B5BB04B34D559C54F92D74422
drop proc sp_upd_FB3B992735854DDED559C54F92D74422
drop proc sp_sel_FB3B992735854DDED559C54F92D74422
drop proc sp_cft_D668822B5BB04B34D559C54F92D74422
drop proc sp_cft_FB3B992735854DDED559C54F92D74422
drop proc sp_ins_CD61955AF2B343D0D559C54F92D74422
drop proc sp_upd_CD61955AF2B343D0D559C54F92D74422
drop proc sp_ins_0F36ADC0CB294985D559C54F92D74422
drop proc sp_sel_CD61955AF2B343D0D559C54F92D74422
drop proc sp_upd_0F36ADC0CB294985D559C54F92D74422
drop proc sp_sel_0F36ADC0CB294985D559C54F92D74422
drop proc sp_cft_CD61955AF2B343D0D559C54F92D74422
drop proc sp_cft_0F36ADC0CB294985D559C54F92D74422
drop proc sp_ins_CD5CE7B008C84888D559C54F92D74422
drop proc sp_upd_CD5CE7B008C84888D559C54F92D74422
drop proc sp_ins_3FF08AC3D7E44180D559C54F92D74422
drop proc sp_sel_CD5CE7B008C84888D559C54F92D74422
drop proc sp_upd_3FF08AC3D7E44180D559C54F92D74422
drop proc sp_sel_3FF08AC3D7E44180D559C54F92D74422
drop proc sp_cft_CD5CE7B008C84888D559C54F92D74422
drop proc sp_cft_3FF08AC3D7E44180D559C54F92D74422
drop proc sp_ins_A19C5A2493074A9CD559C54F92D74422
drop proc sp_upd_A19C5A2493074A9CD559C54F92D74422
drop proc sp_ins_D2AF7B154DEB4255D559C54F92D74422
drop proc sp_sel_A19C5A2493074A9CD559C54F92D74422
drop proc sp_upd_D2AF7B154DEB4255D559C54F92D74422
drop proc sp_sel_D2AF7B154DEB4255D559C54F92D74422
drop proc sp_cft_A19C5A2493074A9CD559C54F92D74422
drop proc sp_cft_D2AF7B154DEB4255D559C54F92D74422
drop proc sp_ins_C172FF6E4C0E4BABD559C54F92D74422
drop proc sp_upd_C172FF6E4C0E4BABD559C54F92D74422
drop proc sp_ins_D7949F529EA34D4BD559C54F92D74422
drop proc sp_sel_C172FF6E4C0E4BABD559C54F92D74422
drop proc sp_upd_D7949F529EA34D4BD559C54F92D74422
drop proc sp_sel_D7949F529EA34D4BD559C54F92D74422
drop proc sp_cft_C172FF6E4C0E4BABD559C54F92D74422
drop proc sp_ins_A12CF699787F4FD2D559C54F92D74422
drop proc sp_cft_D7949F529EA34D4BD559C54F92D74422
drop proc sp_upd_A12CF699787F4FD2D559C54F92D74422
drop proc sp_ins_9A6161E4E7624983D559C54F92D74422
drop proc sp_sel_A12CF699787F4FD2D559C54F92D74422
drop proc sp_upd_9A6161E4E7624983D559C54F92D74422
drop proc sp_ins_61C94C92DB024F7FD559C54F92D74422
drop proc sp_sel_9A6161E4E7624983D559C54F92D74422
drop proc sp_upd_61C94C92DB024F7FD559C54F92D74422
drop proc sp_cft_A12CF699787F4FD2D559C54F92D74422
drop proc sp_sel_61C94C92DB024F7FD559C54F92D74422
drop proc sp_cft_9A6161E4E7624983D559C54F92D74422
drop proc sp_ins_729123C2C5354EF1D559C54F92D74422
drop proc sp_cft_61C94C92DB024F7FD559C54F92D74422
drop proc sp_upd_729123C2C5354EF1D559C54F92D74422
drop proc sp_ins_7A691DF5285B4496D559C54F92D74422
drop proc sp_sel_729123C2C5354EF1D559C54F92D74422
drop proc sp_upd_7A691DF5285B4496D559C54F92D74422
drop proc sp_ins_059A7C4F47E24A51D559C54F92D74422
drop proc sp_sel_7A691DF5285B4496D559C54F92D74422
drop proc sp_upd_059A7C4F47E24A51D559C54F92D74422
drop proc sp_cft_729123C2C5354EF1D559C54F92D74422
drop proc sp_sel_059A7C4F47E24A51D559C54F92D74422
drop proc sp_cft_7A691DF5285B4496D559C54F92D74422
drop proc sp_ins_95E2390573A84D16D559C54F92D74422
drop proc sp_cft_059A7C4F47E24A51D559C54F92D74422
drop proc sp_upd_95E2390573A84D16D559C54F92D74422
drop proc sp_ins_AD73B61E18DB4A04D559C54F92D74422
drop proc sp_sel_95E2390573A84D16D559C54F92D74422
drop proc sp_upd_AD73B61E18DB4A04D559C54F92D74422
drop proc sp_ins_A30B9421B5EC45AFD559C54F92D74422
drop proc sp_sel_AD73B61E18DB4A04D559C54F92D74422
drop proc sp_upd_A30B9421B5EC45AFD559C54F92D74422
drop proc sp_cft_95E2390573A84D16D559C54F92D74422
drop proc sp_sel_A30B9421B5EC45AFD559C54F92D74422
drop proc sp_cft_AD73B61E18DB4A04D559C54F92D74422
drop proc sp_ins_4E3D899E672844FFD559C54F92D74422
drop proc sp_cft_A30B9421B5EC45AFD559C54F92D74422
drop proc sp_upd_4E3D899E672844FFD559C54F92D74422
drop proc sp_ins_3A22986CDFDC4A38D559C54F92D74422
drop proc sp_sel_4E3D899E672844FFD559C54F92D74422
drop proc sp_upd_3A22986CDFDC4A38D559C54F92D74422
drop proc sp_ins_921BEE785EDA4539D559C54F92D74422
drop proc sp_sel_3A22986CDFDC4A38D559C54F92D74422
drop proc sp_upd_921BEE785EDA4539D559C54F92D74422
drop proc sp_cft_4E3D899E672844FFD559C54F92D74422
drop proc sp_sel_921BEE785EDA4539D559C54F92D74422
drop proc sp_cft_3A22986CDFDC4A38D559C54F92D74422
drop proc sp_ins_316B988DBB2841FAD559C54F92D74422
drop proc sp_cft_921BEE785EDA4539D559C54F92D74422
drop proc sp_upd_316B988DBB2841FAD559C54F92D74422
drop proc sp_ins_DADD052666354C2BD559C54F92D74422
drop proc sp_sel_316B988DBB2841FAD559C54F92D74422
drop proc sp_upd_DADD052666354C2BD559C54F92D74422
drop proc sp_ins_3396E764DEE44C21D559C54F92D74422
drop proc sp_sel_DADD052666354C2BD559C54F92D74422
drop proc sp_upd_3396E764DEE44C21D559C54F92D74422
drop proc sp_cft_316B988DBB2841FAD559C54F92D74422
drop proc sp_sel_3396E764DEE44C21D559C54F92D74422
drop proc sp_cft_DADD052666354C2BD559C54F92D74422
drop proc sp_ins_4E5E01826A0D4F66D559C54F92D74422
drop proc sp_cft_3396E764DEE44C21D559C54F92D74422
drop proc sp_upd_4E5E01826A0D4F66D559C54F92D74422
drop proc sp_ins_8CCE4DE24BB242A7D559C54F92D74422
drop proc sp_sel_4E5E01826A0D4F66D559C54F92D74422
drop proc sp_upd_8CCE4DE24BB242A7D559C54F92D74422
drop proc sp_ins_C9E6B7898760458ED559C54F92D74422
drop proc sp_sel_8CCE4DE24BB242A7D559C54F92D74422
drop proc sp_upd_C9E6B7898760458ED559C54F92D74422
drop proc sp_cft_4E5E01826A0D4F66D559C54F92D74422
drop proc sp_sel_C9E6B7898760458ED559C54F92D74422
drop proc sp_cft_8CCE4DE24BB242A7D559C54F92D74422
drop proc sp_ins_731CD2C246C34B48D559C54F92D74422
drop proc sp_cft_C9E6B7898760458ED559C54F92D74422
drop proc sp_upd_731CD2C246C34B48D559C54F92D74422
drop proc sp_ins_A1A87C0FB71D4B04D559C54F92D74422
drop proc sp_sel_731CD2C246C34B48D559C54F92D74422
drop proc sp_upd_A1A87C0FB71D4B04D559C54F92D74422
drop proc sp_ins_82A7978C48E9483CD559C54F92D74422
drop proc sp_sel_A1A87C0FB71D4B04D559C54F92D74422
drop proc sp_upd_82A7978C48E9483CD559C54F92D74422
drop proc sp_cft_731CD2C246C34B48D559C54F92D74422
drop proc sp_sel_82A7978C48E9483CD559C54F92D74422
drop proc sp_cft_A1A87C0FB71D4B04D559C54F92D74422
drop proc sp_ins_A65A2CCEA4C5407ED559C54F92D74422
drop proc sp_cft_82A7978C48E9483CD559C54F92D74422
drop proc sp_upd_A65A2CCEA4C5407ED559C54F92D74422
drop proc sp_ins_38F543CC00EE4209D559C54F92D74422
drop proc sp_sel_A65A2CCEA4C5407ED559C54F92D74422
drop proc sp_upd_38F543CC00EE4209D559C54F92D74422
drop proc sp_sel_38F543CC00EE4209D559C54F92D74422
drop proc sp_cft_A65A2CCEA4C5407ED559C54F92D74422
drop proc sp_cft_38F543CC00EE4209D559C54F92D74422
drop proc sp_ins_5E09CA24B0C04999D559C54F92D74422
drop proc sp_upd_5E09CA24B0C04999D559C54F92D74422
drop proc sp_ins_C9CF021DDD834721D559C54F92D74422
drop proc sp_sel_5E09CA24B0C04999D559C54F92D74422
drop proc sp_upd_C9CF021DDD834721D559C54F92D74422
drop proc sp_sel_C9CF021DDD834721D559C54F92D74422
drop proc sp_cft_5E09CA24B0C04999D559C54F92D74422
drop proc sp_cft_C9CF021DDD834721D559C54F92D74422
drop proc sp_ins_F67721140C51497FD559C54F92D74422
drop proc sp_upd_F67721140C51497FD559C54F92D74422
drop proc sp_ins_72989293CA5141F0D559C54F92D74422
drop proc sp_sel_F67721140C51497FD559C54F92D74422
drop proc sp_upd_72989293CA5141F0D559C54F92D74422
drop proc sp_sel_72989293CA5141F0D559C54F92D74422
(164 row(s) affected)
------------------------------------------------------------------------------------------------------------------------------------------
drop view tsvw_059A7C4F47E24A51B72F8F81D3F90C2B
drop view tsvw_0F36ADC0CB29498597CF0B4069878C79
drop view tsvw_316B988DBB2841FA9498B5A070715306
drop view tsvw_3396E764DEE44C21A90B74B3DB271713
drop view tsvw_38F543CC00EE4209858E632255B2C94C
drop view tsvw_3A22986CDFDC4A38AD8C507D6EBE0837
drop view tsvw_3FF08AC3D7E441809441539521803651
drop view tsvw_44C3CFBC5855442F883E7A113286C3C3
drop view tsvw_4E3D899E672844FF86DEAD23578167A3
drop view tsvw_4E5E01826A0D4F66BD0359B47A5B1501
drop view tsvw_5E09CA24B0C049999C2F15756307960E
drop view tsvw_5E8D09F582B845E1BED7ACB6DD04BCD6
drop view tsvw_61C94C92DB024F7F82B53C36B832F326
drop view tsvw_729123C2C5354EF1B7E3CE4E295DD60C
drop view tsvw_72989293CA5141F0AC8AA1B5BD45E48A
drop view tsvw_731CD2C246C34B4883540C85DE393CE4
drop view tsvw_749877420DC34B92BF75AE6947A81F4E
drop view tsvw_7A691DF5285B449686550669B69FFC86
drop view tsvw_82A7978C48E9483C8CF745C92979B4BF
drop view tsvw_8B4B6E7A29914AF7A1D2BF672F23B59B
drop view tsvw_8CCE4DE24BB242A7B10CF5039FC7671B
drop view tsvw_921BEE785EDA4539BEC231CA6758EB98
drop view tsvw_95E2390573A84D16BAFECB7734DDA2C7
drop view tsvw_9A6161E4E762498381F1582822596223
drop view tsvw_A12CF699787F4FD2A0E96A841F842693
drop view tsvw_A19C5A2493074A9C9965AD3C90574C34
drop view tsvw_A1A87C0FB71D4B04BBCA57526DBE88AE
drop view tsvw_A30B9421B5EC45AF820BD70DFF4D0473
drop view tsvw_A65A2CCEA4C5407EB1270E655A0C79F9
drop view tsvw_AD73B61E18DB4A04BD509111A5EFA29B
drop view tsvw_C172FF6E4C0E4BABB68E8AD3C3805B2F
drop view tsvw_C9CF021DDD834721A8C96B366C3B7425
drop view tsvw_C9E6B7898760458EB82FECC672675824
drop view tsvw_CD5CE7B008C84888AD851B4098026316
drop view tsvw_CD61955AF2B343D0835699CDD1670B5A
drop view tsvw_D2AF7B154DEB4255821624319169F129
drop view tsvw_D668822B5BB04B34A3DFF296705A0241
drop view tsvw_D7949F529EA34D4BACC9DE601186C0EB
drop view tsvw_DADD052666354C2B9FB29E162FB0A6D9
drop view tsvw_F67721140C51497F9EF3155E58251B0F
drop view tsvw_FB3B992735854DDE886CA78DF508C543
(41 row(s) affected)
------------------------------------------------------------------------------------------------------------------------------------------
drop view ctsv_059A7C4F47E24A51B72F8F81D3F90C2B
drop view ctsv_0F36ADC0CB29498597CF0B4069878C79
drop view ctsv_316B988DBB2841FA9498B5A070715306
drop view ctsv_3396E764DEE44C21A90B74B3DB271713
drop view ctsv_38F543CC00EE4209858E632255B2C94C
drop view ctsv_3A22986CDFDC4A38AD8C507D6EBE0837
drop view ctsv_3FF08AC3D7E441809441539521803651
drop view ctsv_44C3CFBC5855442F883E7A113286C3C3
drop view ctsv_4E3D899E672844FF86DEAD23578167A3
drop view ctsv_4E5E01826A0D4F66BD0359B47A5B1501
drop view ctsv_5E09CA24B0C049999C2F15756307960E
drop view ctsv_5E8D09F582B845E1BED7ACB6DD04BCD6
drop view ctsv_61C94C92DB024F7F82B53C36B832F326
drop view ctsv_729123C2C5354EF1B7E3CE4E295DD60C
drop view ctsv_72989293CA5141F0AC8AA1B5BD45E48A
drop view ctsv_731CD2C246C34B4883540C85DE393CE4
drop view ctsv_749877420DC34B92BF75AE6947A81F4E
drop view ctsv_7A691DF5285B449686550669B69FFC86
drop view ctsv_82A7978C48E9483C8CF745C92979B4BF
drop view ctsv_8B4B6E7A29914AF7A1D2BF672F23B59B
drop view ctsv_8CCE4DE24BB242A7B10CF5039FC7671B
drop view ctsv_921BEE785EDA4539BEC231CA6758EB98
drop view ctsv_95E2390573A84D16BAFECB7734DDA2C7
drop view ctsv_9A6161E4E762498381F1582822596223
drop view ctsv_A12CF699787F4FD2A0E96A841F842693
drop view ctsv_A19C5A2493074A9C9965AD3C90574C34
drop view ctsv_A1A87C0FB71D4B04BBCA57526DBE88AE
drop view ctsv_A30B9421B5EC45AF820BD70DFF4D0473
drop view ctsv_A65A2CCEA4C5407EB1270E655A0C79F9
drop view ctsv_AD73B61E18DB4A04BD509111A5EFA29B
drop view ctsv_C172FF6E4C0E4BABB68E8AD3C3805B2F
drop view ctsv_C9CF021DDD834721A8C96B366C3B7425
drop view ctsv_C9E6B7898760458EB82FECC672675824
drop view ctsv_CD5CE7B008C84888AD851B4098026316
drop view ctsv_CD61955AF2B343D0835699CDD1670B5A
drop view ctsv_D2AF7B154DEB4255821624319169F129
drop view ctsv_D668822B5BB04B34A3DFF296705A0241
drop view ctsv_D7949F529EA34D4BACC9DE601186C0EB
drop view ctsv_DADD052666354C2B9FB29E162FB0A6D9
drop view ctsv_F67721140C51497F9EF3155E58251B0F
drop view ctsv_FB3B992735854DDE886CA78DF508C543
(41 row(s) affected)
-------------------------------------------------------------------------------------------------------------------------------------------
drop table MSmerge_altsyncpartners
drop table MSmerge_contents
drop table MSmerge_delete_conflicts
drop table MSmerge_errorlineage
drop table MSmerge_genhistory
drop table MSmerge_replinfo
drop table MSmerge_tombstone
(7 row(s) affected)
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply