System procedures hold table lock  Other changes to system procedures

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

System procedures that synchronize changes

The following 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.





Copyright © 2005. Sybase Inc. All rights reserved. Other changes to system procedures

View this book as PDF