Table B-2 lists the system procedures that synchronize changes between the primary companion and the secondary companion. For example, if you use sp_droplanguage to drop the French language from the primary companion, sp_droplanguage also drops it from the secondary companion.
You can issue these system procedures from any database.
sp_addexternlogin |
sp_dropremotelogin, |
sp_addlanguage |
sp_drop_resource_limit |
sp_addlogin |
sp_dropserver |
sp_addremotelogin |
sp_drop_time_range |
sp_add_resource_limit |
sp_locklogin |
sp_addserver |
sp_modifylogin |
sp_add_time_range |
sp_modify_resource_limit |
sp_defaultdb |
sp_modify_time_range |
sp_defaultlanguage |
sp_password |
sp_dropexternlogin |
sp_remoteoption |
sp_droplanguage |
sp_serveroption |
sp_droplogin |
sp_setlangalias |
The following system procedures synchronize changes between the primary companion and the secondary companion when you issue them from the master database.
sp_addalias
sp_addgroup
sp_addtype
sp_adduser
sp_changegroup
sp_dropalias
sp_dropgroup
sp_droptype
sp_dropuser