Appendix B: Changes to Commands, System Procedures, and System Databases

System procedures that synchronize changes

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.

**Table B-2: System procedures that synchronize changes to both companions**
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

View this book as PDF