Problems w/Install of Service Pack 4

Question

Post reply

Problems w/Install of Service Pack 4

Thomas Johnson-219652

SSC Veteran

Points: 240
More actions
January 25, 2006 at 12:22 pm

#170185

I previously downloaded and attempted to instal MSSQL Service Pack4. It appears to go on its merry way with the upgrad until it reaches about tw dozen Read-Only modules. In each case I answer "OverWrite" until it tries to process Replsys.sql. I get the following message "Error Running script:Replsys.sql(1)" When I close this error box the whole install process shuts down without any error message about exceptions, logs, or where I should go to correct this problem. Also, it has a file "smssql2ksp4.pdf" which cannot be brought up in Adobe? Have I gotten hold of an invalid copy of this upgrade? An assistance would be appreciated. . .Thanks in advance Tom J.
Kindest Regards,
Thomas Johnson
A+, MCP, MCSD .Net, C#
Pray to the one who scraficed for you

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Fred Williams-134192 SSCrazy Points: 2432 More actions · Answer 1

Fred Williams-134192

SSCrazy

Points: 2432

January 25, 2006 at 12:56 pm

#617017

Look in the file replsys.out for clues.

Thomas Johnson-219652 SSC Veteran Points: 240 More actions · Answer 2

Thanks Fred for the quick response. I am including the replsys.out log for another set of eyes. I can't find a thing in this log that would cause the type of behavior that I described. As you can see the end of the log says that this script executed successfully?? Since there is no overall Log or instructions that outline what should run next, I guess I am at a standstill for resolving this problem. Any more ideas would be appreciated. Thanks in advance . . .Tom J.

DBCC execution completed. If DBCC printed error messages, contact your

system administrator.

Configuration option 'allow updates' changed from 0 to 1. Run the

RECONFIGURE statement to install.

DBCC execution completed. If DBCC printed error messages, contact your

system administrator.

Creating procedure xp_execresultset

Creating procedure sp_execresultset

Creating procedure sp_MSispulldistributionjobnamegenerated

Creating procedure sp_MSispullmergejobnamegenerated

Creating function fn_escapecmdshellsymbols

Creating function fn_escapecmdshellsymbolsremovequotes

Creating function fn_repltrimleadingzerosinhexstr

Creating function fn_replinttobitstring

Creating function fn_replbitstringtoint

Creating function fn_replrotr

Creating function fn_replgenerateshorterfilenameprefix

Creating function fn_replcomposepublicationsnapshotfolder

Creating procedure sp_MSdroparticleconstraints

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSreplcheck_subscribe'. The

stored procedure will still be created.

Creating procedure sp_MSacquireserverresourcefordynamicsnapshot

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSreplcheck_publish'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSacquireHeadofQueueLock'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSacquireSlotLock'. The stored

procedure will still be created.

Creating function fn_replgetbinary8lodword

Creating function fn_replprepadbinary8

Creating function fn_replmakestringliteral

Creating procedure sp_MSgettranlastupdatedtime

Creating procedure sp_MSgetmergelastupdatedtime

Creating procedure sp_MSgetlastupdatedtime

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSreplcheck_subscribe'. The

stored procedure will still be created.

Creating function fn_repladjustcolumnmap

Creating function fn_replquotename

Creating function fn_chariswhitespace

Creating function fn_generateparameterpattern

Creating function fn_skipparameterargument

Creating function fn_reomveparameterwithargument

Creating function fn_updateparameterwithargument

Creating procedure sp_MSreplcheckoffloadserver

Creating function fn_repluniquename

Creating procedure sp_MSget_file_existence

Creating procedure sp_MSrepl_isdbowner

Creating procedure sp_resyncmergesubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSreplcheck_publish'. The

stored procedure will still be created.

Creating procedure sp_MSget_qualified_name

Creating procedure sp_MSdrop_object

Creating procedure sp_isarticlecolbitset

Creating procedure sp_getarticlepkcolbitmap

Creating procedure sp_MSsubst_filter_name

Creating procedure sp_MSsubst_filter_names

Creating procedure sp_MScheckvalidsystables

Creating procedure sp_MSdrop_mergesystables

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSremovedebuginfrastructure'.

The stored procedure will still be created.

Executing procedure dbo.sp_MSdrop_mergesystables.

Creating procedure sp_MScreate_mergesystables

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MScreatedebuginfrastructure'.

The stored procedure will still be created.

Creating procedure sp_MStestbit

Creating procedure sp_MSsetbit

Creating procedure sp_MSinsertcontents

Creating procedure sp_MSupdatecontents

Creating 'sp_MSdeletecontents'.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSgetreplnick'. The stored

procedure will still be created.

Creating procedure sp_MSunmarkifneeded

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSunmarkreplinfo'. The stored

procedure will still be created.

Creating procedure sp_MSunmarkreplinfo

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSreplcheck_subscribe'. The

stored procedure will still be created.

Creating procedure sp_MSmarkreplinfo

Creating procedure sp_MSunmarkschemaobject

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSreplcheck_subscribe'. The

stored procedure will still be created.

Creating procedure sp_MSmarkschemaobject

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSreplcheck_subscribe'. The

stored procedure will still be created.

Creating procedure sp_MSaddanonymousreplica

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSreplcheck_subscribe'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_addmergepullsubscription'.

The stored procedure will still be created.

Creating procedure sp_MSgetreplicainfo

Creating procedure sp_MSadd_repl_job

Creating procedure sp_MScheck_subscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSreplcheck_pull'. The stored

procedure will still be created.

Creating 'sp_MSgettools_path'.

Creating procedure sp_replicationoption

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'master.dbo.sp_MSget_setup_paths'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_replicationoption'. The

stored procedure will still be created.

Creating procedure sp_helpreplicationoption

Creating procedure sp_MSgetreplnick

Creating procedure sp_MSreplcheck_publish

Creating procedure sp_MSlocktable

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSrepl_PAL_rolecheck'. The

stored procedure will still be created.

Creating procedure sp_MSenumcolumns

Creating procedure sp_MSsetaccesslist

Creating procedure sp_MSreplcheck_pull

Creating procedure sp_MSreplcheck_connection

Creating procedure sp_MSrepl_PAL_rolecheck

Creating procedure sp_MSreplcheck_qv

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'master.dbo.sp_MSinstance_qv'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'master.dbo.sp_MSinstance_qv'. The

stored procedure will still be created.

Creating procedure sp_reinitmergepullsubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSreplcheck_subscribe'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSCleanupForPullReinit'. The

stored procedure will still be created.

Creating procedure sp_MSreplcheck_subscribe

Creating procedure sp_MSreplicationcompatlevel

Creating procedure sp_MShelp_identity_property

Creating procedure sp_MSgenreplnickname

Creating procedure sp_MSmergesubscribedb

Creating procedure sp_MSenumallsubscriptions

Creating procedure sp_MSenumsubscriptions

Creating procedure sp_MSenumallpublications

Creating procedure sp_MSenumtranpublications

Creating procedure sp_MSenummergepublications

Creating procedure sp_MSenum3rdpartypublications

Creating procedure sp_MSenumthirdpartypublicationvendornames

Creating procedure sp_reinitpullsubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSreset_attach_state'. The

stored procedure will still be created.

Creating procedure sp_addpullsubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MS_replication_installed'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MScreate_sub_tables'. The

stored procedure will still be created.

Creating procedure sp_MSupdatesharedagentproperties

Creating procedure sp_replicationdboption

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_replicationdboption'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_replicationdboption'. The

stored procedure will still be created.

Creating procedure sp_MSfixupdistributorinfo

Creating procedure sp_MSfixupdistributorsecurity

Creating procedure sp_MSfixupftpinfo

Creating procedure sp_MSfixupaltsnapshotfolder

Creating procedure sp_MSfixupworkingdirectory

Creating procedure sp_MSfixupuseftp

Creating procedure sp_MSfixup_offload_agent_info

Creating procedure sp_MSfixupsharedagentproperties

Creating procedure sp_addpullsubscription_agent

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MScreate_sub_tables'. The stored

procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSregistersubscription'. The

stored procedure will still be created.

Creating procedure sp_helpsubscription_properties

Creating procedure sp_change_subscription_properties

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSremoveoffloadparameter'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSaddoffloadparameter'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSaddoffloadparameter'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Creating procedure sp_MSget_pullsubsagent_owner

Creating procedure sp_droppullsubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_droppullsubscription'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSunregistersubscription'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSsub_cleanup_prop_table'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_subscription_cleanup'. The

stored procedure will still be created.

Creating procedure sp_helppullsubscription

Creating procedure sp_MStable_has_unique_index

Creating procedure sp_MSchange_retention

Creating procedure sp_MSchange_priority

Creating procedure sp_expired_subscription_cleanup

Creating procedure sp_addmergepullsubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MS_replication_installed'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MScreate_sub_tables'. The

stored procedure will still be created.

Creating procedure sp_changemergepullsubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object

'sp_MSsubscription_enabled_for_syncmgr'. The stored procedure will

still be created.

Creating procedure sp_helpmergepullsubscription

Creating procedure sp_addmergepullsubscription_agent

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSregistersubscription'. The

stored procedure will still be created.

Creating procedure sp_MSget_mergepullsubsagent_owner

Creating procedure sp_dropmergepullsubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_dropmergepullsubscription'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_dropmergepullsubscription'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_dropmergepullsubscription'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSunregistersubscription'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSpublicationcleanup'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSsub_cleanup_prop_table'.

The stored procedure will still be created.

Creating procedure sp_MSreplraiserror

Creating procedure sp_check_sync_trigger

Creating procedure sp_check_for_sync_trigger

Creating procedure sp_MSpad_command

Creating procedure sp_MSflush_command

Creating procedure sp_MSget_colinfo

Creating procedure sp_MSget_col_position

Creating procedure sp_MSget_map_position

Creating procedure sp_MSget_type

Creating procedure sp_MSscript_where_clause

Creating procedure sp_MSscript_params

Creating procedure sp_MSscript_procbodystart

Creating procedure sp_MSscript_begintrig1

Creating procedure sp_MSscript_begintrig2

Creating procedure sp_MSscript_endtrig

Creating procedure sp_MSscript_trigger_variables

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSget_synctran_column'. The

stored procedure will still be created.

Creating procedure sp_MSscript_trigger_assignment

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSget_synctran_column'. The

stored procedure will still be created.

Creating procedure sp_MSscript_trigger_fetch_statement

Creating procedure sp_MSscript_trigger_exec_rpc

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object

'dbo.sp_MSscript_trigger_version_updates'. The stored procedure will

still be created.

Creating procedure sp_MSscript_trigger_update_checks

Creating procedure sp_MSscript_trigger_updates

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSscript_pkvar_assignment'.

The stored procedure will still be created.

Creating procedure sp_MSscript_trigger_version_updates

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSscript_pkvar_assignment'.

The stored procedure will still be created.

Creating procedure sp_MSscript_singlerow_trigger

Creating procedure sp_MSscript_multirow_trigger

Creating procedure sp_MSscript_sync_ins_trig

Creating procedure sp_MSscript_sync_upd_trig

Creating procedure sp_MSscript_sync_del_trig

Creating procedure sp_MSget_synctran_column

Creating procedure sp_addqueued_artinfo

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSreset_queue'. The stored

procedure will still be created.

Creating procedure sp_addsynctriggers

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MScreate_sub_tables'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MScreate_sub_tables'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_link_publication'. The stored

procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSsub_cleanup_orphans'. The

stored procedure will still be created.

Creating procedure sp_setreplfailovermode

Creating procedure sp_helpreplfailovermode

Creating procedure sp_helpreplicationdboption

Creating procedure sp_MScheck_agent_instance

Creating procedure sp_MSpublicationcleanup

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSarticlecleanup'. The stored

procedure will still be created.

Creating procedure sp_removedbreplication

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSarticlecleanup'. The stored

procedure will still be created.

Creating procedure sp_MSarticlecleanup

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSdroparticleprocs'. The stored

procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSdroparticletriggers'. The

stored procedure will still be created.

Creating procedure sp_MSdroparticleprocs

Creating procedure sp_MSdroparticletriggers

Creating procedure sp_mergesubscription_cleanup

Creating procedure sp_subscription_cleanup

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSreseed'. The stored

procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSsub_cleanup_prop_table'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSsub_cleanup_orphans'. The

stored procedure will still be created.

Creating procedure sp_get_distributor

Creating procedure sp_MSrepl_addrolemember

Creating procedure sp_MSrepl_droprolemember

Creating procedure sp_table_validation

Creating procedure sp_removedbreplication

Creating procedure sp_removesrvreplication

Creating procedure sp_MSremovedbreplication

Creating procedure sp_vupgrade_subscription_databases

Creating procedure sp_MScopyregvalue

Creating procedure sp_vupgrade_registry

Creating procedure sp_vupgrade_subscription_tables

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MScreate_sub_tables'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MScreate_sub_tables'. The stored

procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MScreate_sub_tables'. The stored

procedure will still be created.

Creating procedure sp_vupgrade_mergetables

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSUpgradeConflictTable'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSrepl_FixPALRole'. The stored

procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSpurgecontentsorphans'. The

stored procedure will still be created.

Creating procedure sp_vupgrade_subpass

Creating procedure sp_vupgrade_MSsubscription_properties

Creating procedure sp_vupgrade_replication

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'master.dbo.sp_MSget_setup_paths'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_vupgrade_publisher'. The

stored procedure will still be created.

Creating procedure sp_vupgrade_distdb

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSupdate_mqserver_distdb'.

The stored procedure will still be created.

Creating procedure sp_vupgrade_publisher

Creating procedure sp_vupgrade_syscol_status

Creating procedure sp_vupgrade_publisherdb

Creating procedure sp_vupgrade_replmsdb

Creating procedure sp_restoredbreplication

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSrepl_backup_start'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSrepl_backup_complete'. The

stored procedure will still be created.

Creating procedure sp_MSget_publisher_rpc

Creating procedure sp_link_publication

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MScreate_sub_tables'. The

stored procedure will still be created.

Creating procedure sp_MSreset_queue

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MScreate_sub_tables'. The stored

procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MScreate_sub_tables'. The stored

procedure will still be created.

Creating procedure sp_MSreset_queued_reinit

Creating procedure sp_MSinit_subscription_agent

Creating procedure sp_MSupdatelastsyncinfo

Creating procedure sp_MSget_attach_state

Creating procedure sp_MSreset_attach_state

Creating procedure sp_MSset_subscription_properties

Creating procedure sp_MSset_sub_guid

Creating procedure sp_populateqtraninfo

Creating procedure sp_MScreate_sub_tables

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSupdate_mqserver_subdb'. The

stored procedure will still be created.

Creating procedure sp_MSupdate_mqserver_subdb

Creating procedure sp_MS_replication_installed

Creating procedure sp_MSunc_to_drive

Creating procedure sp_MSretrieve_publication_attributes

Creating procedure sp_MScleanup_publication_ADinfo

Creating procedure sp_MSrepl_linkedservers_rowset

Creating procedure sp_MSregistersubscription

Creating procedure sp_MSunregistersubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object

'sp_MSsubscription_enabled_for_syncmgr'. The stored procedure will

still be created.

Creating procedure sp_MSsubscription_enabled_for_syncmgr

Creating procedure sp_MSget_jobstate

Creating procedure sp_MSscript_pkvar_assignment

Creating procedure sp_MSget_publication_from_taskname

Creating procedure sp_MSacquireHeadofQueueLock

Creating procedure sp_MSacquireSlotLock

Creating procedure sp_MSreleaseSlotLock

Creating procedure sp_MSrepl_check_server

Creating procedure sp_MSreset_synctran_bit

Creating procedure sp_MSenum_replsqlqueues

Creating procedure sp_MSenum_replqueues

Creating procedure sp_browsemergesnapshotfolder

Creating procedure sp_browsesnapshotfolder

Creating procedure sp_MScopysnapshot

Creating procedure sp_copymergesnapshot

Creating procedure sp_copysnapshot

Creating procedure sp_MSrepl_validate_dts_package

Creating procedure sp_MSget_load_hint

Creating procedure sp_getsubscriptiondtspackagename

Creating procedure sp_MSverifytranfilter

Creating procedure sp_repldropcolumn

Creating procedure sp_repladdcolumn

Creating procedure sp_MSagent_access_check

Creating procedure sp_enableagentoffload

Creating procedure sp_disableagentoffload

Creating procedure sp_getagentoffloadinfo

Creating procedure sp_copysubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'master.dbo.sp_MSget_setup_paths'.

The stored procedure will still be created.

Creating procedure sp_attachsubscription

Creating procedure sp_MSrestore_sub_merge

Creating procedure sp_MSrestore_sub_tran

Creating procedure sp_MSrestore_sub

Creating procedure sp_validatemergepullsubscription

Creating procedure sp_MSprepare_sub_for_detach

Creating procedure sp_MSsub_check_identity

Creating procedure sp_MSsub_cleanup_orphans

Creating procedure sp_MSsub_cleanup_prop_table

Creating procedure sp_MSreseed

Creating procedure sp_MSsub_set_identity

Creating procedure sp_MSinstance_qv

Creating procedure sp_MSget_shared_agent

Creating procedure sp_MSrepl_backup_start

Creating procedure sp_MSrepl_backup_complete

Creating procedure sp_MSadd_compensating_cmd

Creating 'fn_MSsharedversion'.

Creating 'sp_MSget_setup_paths'.

Creating 'sp_MSremoveoffloadparameter'.

Creating 'sp_MSaddoffloadparameter'.

Creating 'fn_MSgensqescstr'.

Creating 'sp_MSUpgradeConflictTable'.

Creating 'sp_MSsendtosqlqueue'.

Creating 'sp_adjustpublisheridentityrange'.

Creating 'sp_MSestimatemergesnapshotworkload'.

Creating 'sp_MSestimatesnapshotworkload'.

Creating procedure sp_MSdropfkreferencingarticle

Creating procedure sp_MSmergeupdatelastsyncinfo

Creating procedure sp_MSrepl_FixPALRole

Creating procedure sp_createmergepalrole

DBCC execution completed. If DBCC printed error messages, contact your

system administrator.

Configuration option 'allow updates' changed from 1 to 0. Run the

RECONFIGURE statement to install.

Checking objects created by replsys.sql.

DBCC execution completed. If DBCC printed error messages, contact your

system administrator.

replsys.sql completed successfully.

DBCC execution completed. If DBCC printed error messages, contact your

system administrator.

Configuration option 'allow updates' changed from 0 to 1. Run the

RECONFIGURE statement to install.

DBCC execution completed. If DBCC printed error messages, contact your

system administrator.

Creating procedure xp_execresultset

Creating procedure sp_execresultset

Creating procedure sp_MSispulldistributionjobnamegenerated

Creating procedure sp_MSispullmergejobnamegenerated

Creating function fn_escapecmdshellsymbols

Creating function fn_escapecmdshellsymbolsremovequotes

Creating function fn_repltrimleadingzerosinhexstr

Creating function fn_replinttobitstring

Creating function fn_replbitstringtoint

Creating function fn_replrotr

Creating function fn_replgenerateshorterfilenameprefix

Creating function fn_replcomposepublicationsnapshotfolder

Creating procedure sp_MSdroparticleconstraints

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSreplcheck_subscribe'. The

stored procedure will still be created.

Creating procedure sp_MSacquireserverresourcefordynamicsnapshot

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSreplcheck_publish'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSacquireHeadofQueueLock'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSacquireSlotLock'. The stored

procedure will still be created.

Creating function fn_replgetbinary8lodword

Creating function fn_replprepadbinary8

Creating function fn_replmakestringliteral

Creating procedure sp_MSgettranlastupdatedtime

Creating procedure sp_MSgetmergelastupdatedtime

Creating procedure sp_MSgetlastupdatedtime

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSreplcheck_subscribe'. The

stored procedure will still be created.

Creating function fn_repladjustcolumnmap

Creating function fn_replquotename

Creating function fn_chariswhitespace

Creating function fn_generateparameterpattern

Creating function fn_skipparameterargument

Creating function fn_reomveparameterwithargument

Creating function fn_updateparameterwithargument

Creating procedure sp_MSreplcheckoffloadserver

Creating function fn_repluniquename

Creating procedure sp_MSget_file_existence

Creating procedure sp_MSrepl_isdbowner

Creating procedure sp_resyncmergesubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSreplcheck_publish'. The

stored procedure will still be created.

Creating procedure sp_MSget_qualified_name

Creating procedure sp_MSdrop_object

Creating procedure sp_isarticlecolbitset

Creating procedure sp_getarticlepkcolbitmap

Creating procedure sp_MSsubst_filter_name

Creating procedure sp_MSsubst_filter_names

Creating procedure sp_MScheckvalidsystables

Creating procedure sp_MSdrop_mergesystables

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSremovedebuginfrastructure'.

The stored procedure will still be created.

Executing procedure dbo.sp_MSdrop_mergesystables.

Creating procedure sp_MScreate_mergesystables

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MScreatedebuginfrastructure'.

The stored procedure will still be created.

Creating procedure sp_MStestbit

Creating procedure sp_MSsetbit

Creating procedure sp_MSinsertcontents

Creating procedure sp_MSupdatecontents

Creating 'sp_MSdeletecontents'.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSgetreplnick'. The stored

procedure will still be created.

Creating procedure sp_MSunmarkifneeded

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSunmarkreplinfo'. The stored

procedure will still be created.

Creating procedure sp_MSunmarkreplinfo

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSreplcheck_subscribe'. The

stored procedure will still be created.

Creating procedure sp_MSmarkreplinfo

Creating procedure sp_MSunmarkschemaobject

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSreplcheck_subscribe'. The

stored procedure will still be created.

Creating procedure sp_MSmarkschemaobject

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSreplcheck_subscribe'. The

stored procedure will still be created.

Creating procedure sp_MSaddanonymousreplica

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSreplcheck_subscribe'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_addmergepullsubscription'.

The stored procedure will still be created.

Creating procedure sp_MSgetreplicainfo

Creating procedure sp_MSadd_repl_job

Creating procedure sp_MScheck_subscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSreplcheck_pull'. The stored

procedure will still be created.

Creating 'sp_MSgettools_path'.

Creating procedure sp_replicationoption

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'master.dbo.sp_MSget_setup_paths'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_replicationoption'. The

stored procedure will still be created.

Creating procedure sp_helpreplicationoption

Creating procedure sp_MSgetreplnick

Creating procedure sp_MSreplcheck_publish

Creating procedure sp_MSlocktable

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSrepl_PAL_rolecheck'. The

stored procedure will still be created.

Creating procedure sp_MSenumcolumns

Creating procedure sp_MSsetaccesslist

Creating procedure sp_MSreplcheck_pull

Creating procedure sp_MSreplcheck_connection

Creating procedure sp_MSrepl_PAL_rolecheck

Creating procedure sp_MSreplcheck_qv

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'master.dbo.sp_MSinstance_qv'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'master.dbo.sp_MSinstance_qv'. The

stored procedure will still be created.

Creating procedure sp_reinitmergepullsubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSreplcheck_subscribe'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSCleanupForPullReinit'. The

stored procedure will still be created.

Creating procedure sp_MSreplcheck_subscribe

Creating procedure sp_MSreplicationcompatlevel

Creating procedure sp_MShelp_identity_property

Creating procedure sp_MSgenreplnickname

Creating procedure sp_MSmergesubscribedb

Creating procedure sp_MSenumallsubscriptions

Creating procedure sp_MSenumsubscriptions

Creating procedure sp_MSenumallpublications

Creating procedure sp_MSenumtranpublications

Creating procedure sp_MSenummergepublications

Creating procedure sp_MSenum3rdpartypublications

Creating procedure sp_MSenumthirdpartypublicationvendornames

Creating procedure sp_reinitpullsubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSreset_attach_state'. The

stored procedure will still be created.

Creating procedure sp_addpullsubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MS_replication_installed'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MScreate_sub_tables'. The

stored procedure will still be created.

Creating procedure sp_MSupdatesharedagentproperties

Creating procedure sp_replicationdboption

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_replicationdboption'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_replicationdboption'. The

stored procedure will still be created.

Creating procedure sp_MSfixupdistributorinfo

Creating procedure sp_MSfixupdistributorsecurity

Creating procedure sp_MSfixupftpinfo

Creating procedure sp_MSfixupaltsnapshotfolder

Creating procedure sp_MSfixupworkingdirectory

Creating procedure sp_MSfixupuseftp

Creating procedure sp_MSfixup_offload_agent_info

Creating procedure sp_MSfixupsharedagentproperties

Creating procedure sp_addpullsubscription_agent

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MScreate_sub_tables'. The stored

procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSregistersubscription'. The

stored procedure will still be created.

Creating procedure sp_helpsubscription_properties

Creating procedure sp_change_subscription_properties

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSremoveoffloadparameter'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSaddoffloadparameter'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSaddoffloadparameter'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_change_subscription_properties'.

The stored procedure will still be created.

Creating procedure sp_MSget_pullsubsagent_owner

Creating procedure sp_droppullsubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_droppullsubscription'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSunregistersubscription'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSsub_cleanup_prop_table'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_subscription_cleanup'. The

stored procedure will still be created.

Creating procedure sp_helppullsubscription

Creating procedure sp_MStable_has_unique_index

Creating procedure sp_MSchange_retention

Creating procedure sp_MSchange_priority

Creating procedure sp_expired_subscription_cleanup

Creating procedure sp_addmergepullsubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MS_replication_installed'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MScreate_sub_tables'. The

stored procedure will still be created.

Creating procedure sp_changemergepullsubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object

'sp_MSsubscription_enabled_for_syncmgr'. The stored procedure will

still be created.

Creating procedure sp_helpmergepullsubscription

Creating procedure sp_addmergepullsubscription_agent

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSregistersubscription'. The

stored procedure will still be created.

Creating procedure sp_MSget_mergepullsubsagent_owner

Creating procedure sp_dropmergepullsubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_dropmergepullsubscription'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_dropmergepullsubscription'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_dropmergepullsubscription'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSunregistersubscription'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSpublicationcleanup'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSsub_cleanup_prop_table'.

The stored procedure will still be created.

Creating procedure sp_MSreplraiserror

Creating procedure sp_check_sync_trigger

Creating procedure sp_check_for_sync_trigger

Creating procedure sp_MSpad_command

Creating procedure sp_MSflush_command

Creating procedure sp_MSget_colinfo

Creating procedure sp_MSget_col_position

Creating procedure sp_MSget_map_position

Creating procedure sp_MSget_type

Creating procedure sp_MSscript_where_clause

Creating procedure sp_MSscript_params

Creating procedure sp_MSscript_procbodystart

Creating procedure sp_MSscript_begintrig1

Creating procedure sp_MSscript_begintrig2

Creating procedure sp_MSscript_endtrig

Creating procedure sp_MSscript_trigger_variables

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSget_synctran_column'. The

stored procedure will still be created.

Creating procedure sp_MSscript_trigger_assignment

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSget_synctran_column'. The

stored procedure will still be created.

Creating procedure sp_MSscript_trigger_fetch_statement

Creating procedure sp_MSscript_trigger_exec_rpc

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object

'dbo.sp_MSscript_trigger_version_updates'. The stored procedure will

still be created.

Creating procedure sp_MSscript_trigger_update_checks

Creating procedure sp_MSscript_trigger_updates

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSscript_pkvar_assignment'.

The stored procedure will still be created.

Creating procedure sp_MSscript_trigger_version_updates

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSscript_pkvar_assignment'.

The stored procedure will still be created.

Creating procedure sp_MSscript_singlerow_trigger

Creating procedure sp_MSscript_multirow_trigger

Creating procedure sp_MSscript_sync_ins_trig

Creating procedure sp_MSscript_sync_upd_trig

Creating procedure sp_MSscript_sync_del_trig

Creating procedure sp_MSget_synctran_column

Creating procedure sp_addqueued_artinfo

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSreset_queue'. The stored

procedure will still be created.

Creating procedure sp_addsynctriggers

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MScreate_sub_tables'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MScreate_sub_tables'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_link_publication'. The stored

procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSsub_cleanup_orphans'. The

stored procedure will still be created.

Creating procedure sp_setreplfailovermode

Creating procedure sp_helpreplfailovermode

Creating procedure sp_helpreplicationdboption

Creating procedure sp_MScheck_agent_instance

Creating procedure sp_MSpublicationcleanup

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSarticlecleanup'. The stored

procedure will still be created.

Creating procedure sp_removedbreplication

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSarticlecleanup'. The stored

procedure will still be created.

Creating procedure sp_MSarticlecleanup

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSdroparticleprocs'. The stored

procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSdroparticletriggers'. The

stored procedure will still be created.

Creating procedure sp_MSdroparticleprocs

Creating procedure sp_MSdroparticletriggers

Creating procedure sp_mergesubscription_cleanup

Creating procedure sp_subscription_cleanup

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSreseed'. The stored

procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSsub_cleanup_prop_table'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSsub_cleanup_orphans'. The

stored procedure will still be created.

Creating procedure sp_get_distributor

Creating procedure sp_MSrepl_addrolemember

Creating procedure sp_MSrepl_droprolemember

Creating procedure sp_table_validation

Creating procedure sp_removedbreplication

Creating procedure sp_removesrvreplication

Creating procedure sp_MSremovedbreplication

Creating procedure sp_vupgrade_subscription_databases

Creating procedure sp_MScopyregvalue

Creating procedure sp_vupgrade_registry

Creating procedure sp_vupgrade_subscription_tables

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MScreate_sub_tables'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MScreate_sub_tables'. The stored

procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MScreate_sub_tables'. The stored

procedure will still be created.

Creating procedure sp_vupgrade_mergetables

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSUpgradeConflictTable'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSrepl_FixPALRole'. The stored

procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MSpurgecontentsorphans'. The

stored procedure will still be created.

Creating procedure sp_vupgrade_subpass

Creating procedure sp_vupgrade_MSsubscription_properties

Creating procedure sp_vupgrade_replication

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'master.dbo.sp_MSget_setup_paths'.

The stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_vupgrade_publisher'. The

stored procedure will still be created.

Creating procedure sp_vupgrade_distdb

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSupdate_mqserver_distdb'.

The stored procedure will still be created.

Creating procedure sp_vupgrade_publisher

Creating procedure sp_vupgrade_syscol_status

Creating procedure sp_vupgrade_publisherdb

Creating procedure sp_vupgrade_replmsdb

Creating procedure sp_restoredbreplication

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSrepl_backup_start'. The

stored procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSrepl_backup_complete'. The

stored procedure will still be created.

Creating procedure sp_MSget_publisher_rpc

Creating procedure sp_link_publication

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MScreate_sub_tables'. The

stored procedure will still be created.

Creating procedure sp_MSreset_queue

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MScreate_sub_tables'. The stored

procedure will still be created.

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'sp_MScreate_sub_tables'. The stored

procedure will still be created.

Creating procedure sp_MSreset_queued_reinit

Creating procedure sp_MSinit_subscription_agent

Creating procedure sp_MSupdatelastsyncinfo

Creating procedure sp_MSget_attach_state

Creating procedure sp_MSreset_attach_state

Creating procedure sp_MSset_subscription_properties

Creating procedure sp_MSset_sub_guid

Creating procedure sp_populateqtraninfo

Creating procedure sp_MScreate_sub_tables

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'dbo.sp_MSupdate_mqserver_subdb'. The

stored procedure will still be created.

Creating procedure sp_MSupdate_mqserver_subdb

Creating procedure sp_MS_replication_installed

Creating procedure sp_MSunc_to_drive

Creating procedure sp_MSretrieve_publication_attributes

Creating procedure sp_MScleanup_publication_ADinfo

Creating procedure sp_MSrepl_linkedservers_rowset

Creating procedure sp_MSregistersubscription

Creating procedure sp_MSunregistersubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object

'sp_MSsubscription_enabled_for_syncmgr'. The stored procedure will

still be created.

Creating procedure sp_MSsubscription_enabled_for_syncmgr

Creating procedure sp_MSget_jobstate

Creating procedure sp_MSscript_pkvar_assignment

Creating procedure sp_MSget_publication_from_taskname

Creating procedure sp_MSacquireHeadofQueueLock

Creating procedure sp_MSacquireSlotLock

Creating procedure sp_MSreleaseSlotLock

Creating procedure sp_MSrepl_check_server

Creating procedure sp_MSreset_synctran_bit

Creating procedure sp_MSenum_replsqlqueues

Creating procedure sp_MSenum_replqueues

Creating procedure sp_browsemergesnapshotfolder

Creating procedure sp_browsesnapshotfolder

Creating procedure sp_MScopysnapshot

Creating procedure sp_copymergesnapshot

Creating procedure sp_copysnapshot

Creating procedure sp_MSrepl_validate_dts_package

Creating procedure sp_MSget_load_hint

Creating procedure sp_getsubscriptiondtspackagename

Creating procedure sp_MSverifytranfilter

Creating procedure sp_repldropcolumn

Creating procedure sp_repladdcolumn

Creating procedure sp_MSagent_access_check

Creating procedure sp_enableagentoffload

Creating procedure sp_disableagentoffload

Creating procedure sp_getagentoffloadinfo

Creating procedure sp_copysubscription

Cannot add rows to sysdepends for the current stored procedure because

it depends on the missing object 'master.dbo.sp_MSget_setup_paths'.

The stored procedure will still be created.

Creating procedure sp_attachsubscription

Creating procedure sp_MSrestore_sub_merge

Creating procedure sp_MSrestore_sub_tran

Creating procedure sp_MSrestore_sub

Creating procedure sp_validatemergepullsubscription

Creating procedure sp_MSprepare_sub_for_detach

Creating procedure sp_MSsub_check_identity

Creating procedure sp_MSsub_cleanup_orphans

Creating procedure sp_MSsub_cleanup_prop_table

Creating procedure sp_MSreseed

Creating procedure sp_MSsub_set_identity

Creating procedure sp_MSinstance_qv

Creating procedure sp_MSget_shared_agent

Creating procedure sp_MSrepl_backup_start

Creating procedure sp_MSrepl_backup_complete

Creating procedure sp_MSadd_compensating_cmd

Creating 'fn_MSsharedversion'.

Creating 'sp_MSget_setup_paths'.

Creating 'sp_MSremoveoffloadparameter'.

Creating 'sp_MSaddoffloadparameter'.

Creating 'fn_MSgensqescstr'.

Creating 'sp_MSUpgradeConflictTable'.

Creating 'sp_MSsendtosqlqueue'.

Creating 'sp_adjustpublisheridentityrange'.

Creating 'sp_MSestimatemergesnapshotworkload'.

Creating 'sp_MSestimatesnapshotworkload'.

Creating procedure sp_MSdropfkreferencingarticle

Creating procedure sp_MSmergeupdatelastsyncinfo

Creating procedure sp_MSrepl_FixPALRole

Creating procedure sp_createmergepalrole

DBCC execution completed. If DBCC printed error messages, contact your

system administrator.

Configuration option 'allow updates' changed from 1 to 0. Run the

RECONFIGURE statement to install.

Checking objects created by replsys.sql.

DBCC execution completed. If DBCC printed error messages, contact your

system administrator.

replsys.sql completed successfully.

Kindest Regards,

Thomas Johnson
A+, MCP, MCSD .Net, C#
Pray to the one who scraficed for you

Fred Williams-134192 SSCrazy Points: 2432 More actions · Answer 3

Your replsys output looks fine to me, too. What OS and OS service pack are you on?

Also look at sqlsp.out for clues. Two common causes for sp4 install failure are the server not listening on Shared Memory, and other services (like SMS) or clients grabbing the only connection when SQL Server is re-started in single-user mode during the install. Make sure nothing else is trying to connect.

You can see if your server is listening on Shared memory by looking at the SQL Server error log, about 25 lines down from the top:

SQL Server listening on TCP, Shared Memory, Named Pipes

A General Network Error in the setup log is a symtom that could be related to not listening on shared memory.

Thomas Johnson-219652 SSC Veteran Points: 240 More actions · Answer 4

Hey Fred, I followed your suggestion seeking out information in the SQL Log files of my MS 200 SQL server, since I can't find the sqlsp.out file. I did indeed find the line "SQL server listening on TCP, Shared Memory, Named Pipes." I did neglect to mention that I had turned off my instance under Computer Management services.

I have just found something strange under my SQL Server Properties (Configure) - (local) information page. It is showing me that I have a Product Version: of 8.00.2039(SP4)!!??

There seems to be something strange going on in Medville!! If I truely have SQL SP4 installed, it gave me an awfully strange exit. I probably need to do a little bit more checking to verify that the upgrade actually worked! If you have any suggestions, I would appreciate your feedback. Thanks again . . .Tom J.

Kindest Regards,

Thomas Johnson
A+, MCP, MCSD .Net, C#
Pray to the one who scraficed for you

Asela-398517 SSChasing Mays Points: 612 More actions · Answer 5

Server: Msg 2812, Level 16, State 62, Line 37

Could not find stored procedure 'dbo.sp_MS_replication_installed'.

Server: Msg 21002, Level 11, State 1, Procedure sp_addpullsubscription_agent, Line 201

The Distribution Agent for this subscription already exists

Same issue just try to install the Sp4 but got a error now replication is missing the SP?

how do we create?

AusNetIT Solutions
Web Design | Web Hosting | SEO | IT Support