Sybase DC38133-01-0902-01 Microscope & Magnifier User Manual


 
Appendix A. SQL Remote for Adaptive Server Enterprise and
Adaptive Server Anywhere: Differences
Adaptive Server Enterprise proce-
dure
Corresponding Adaptive Server
Anywhere statement
sp_remote_type ALTER REMOTE MES-
SAGE TYPE
sp_drop_remote_type DROP REMOTE MESSAGE TYPE
sp_grant_remote GRANT REMOTE
sp_revoke_remote REVOKE REMOTE
sp_publisher GRANT PUBLISH
sp_publisher REVOKE PUBLISH
sp_create_publication
sp_add_article
sp_add_article_col
CREATE PUBLICATION
sp_add_article
sp_remove_article
sp_add_article_col
sp_remove_article_col
ALTER PUBLICATION
sp_drop_publication DROP PUBLICATION
sp_subscription ‘create’ CREATE SUBSCRIPTION
sp_subscription ‘drop’ DROP SUBSCRIPTION
sp_subscription ‘start’ START SUBSCRIPTION
sp_subscription ‘stop’ STOP SUBSCRIPTION
sp_subscription ‘synchronize’ SYNCHRONIZE SUBSCRIPTION
sp_passthrough_user PASSTHROUGH FOR USERID
sp_passthrough_subscription PASSTHROUGH FOR SUBSCRIP-
TION
sp_passthrough_stop PASSTHROUGH STOP
441