SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Replication
Technical Reference
Replication Tables (Transact-SQL)
conflict_<schema>_<table> (Transact-SQL)
IHarticles (Transact-SQL)
IHcolumns (Transact-SQL)
IHconstrainttypes (Transact-SQL)
IHindextypes (Transact-SQL)
IHpublications (Transact-SQL)
IHpublishercolumnconstraints (Transact-SQL)
IHpublishercolumnindexes (Transact-SQL)
IHpublishercolumns (Transact-SQL)
IHpublisherconstraints (Transact-SQL)
IHpublisherindexes (Transact-SQL)
IHpublishers (Transact-SQL)
IHpublishertables (Transact-SQL)
IHsubscriptions (Transact-SQL)
MSagent_parameters (Transact-SQL)
MSagent_profiles (Transact-SQL)
MSagentparameterlist (Transact-SQL)
MSarticles (Transact-SQL)
MScached_peer_lsns (Transact-SQL)
MSdbms (Transact-SQL)
MSdbms_datatype (Transact-SQL)
MSdbms_datatype_mapping (Transact-SQL)
MSdbms_map (Transact-SQL)
MSdistpublishers (Transact-SQL)
MSdistribution_agents (Transact-SQL)
MSdistribution_history (Transact-SQL)
MSdistributiondbs (Transact-SQL)
MSdistributor (Transact-SQL)
MSdynamicsnapshotjobs (Transact-SQL)
MSdynamicsnapshotviews (Transact-SQL)
MSlogreader_agents (Transact-SQL)
MSlogreader_history (Transact-SQL)
MSmerge_agents (Transact-SQL)
MSmerge_articlehistory (Transact-SQL)
MSmerge_altsyncpartners (Transact-SQL)
MSmerge_conflict_<publication>_<article> (Transact-SQL)
MSmerge_conflicts_info (Transact-SQL)
MSmerge_contents (Transact-SQL)
MSmerge_current_partition_mappings
MSmerge_dynamic_snapshots (Transact-SQL)
MSmerge_errorlineage (Transact-SQL)
MSmerge_generation_partition_mappings (Transact-SQL)
MSmerge_genhistory (Transact-SQL)
MSmerge_history (Transact-SQL)
MSmerge_identity_range (Transact-SQL)
MSmerge_identity_range_allocations (Transact-SQL)
MSmerge_metadataaction_request (Transact-SQL)
MSmerge_partition_groups (Transact-SQL)
MSmerge_past_partition_mappings (Transact-SQL)
MSmerge_replinfo (Transact-SQL)
MSmerge_sessions (Transact-SQL)
MSmerge_settingshistory (Transact-SQL)
MSmerge_subscriptions (Transact-SQL)
MSmerge_tombstone (Transact-SQL)
MSpeer_conflictdetectionconfigrequest (Transact-SQL)
MSpeer_conflictdetectionconfigresponse (Transact-SQL)
MSpeer_lsns (Transact-SQL)
MSpeer_originatorid_history (Transact-SQL)
MSpeer_request (Transact-SQL)
MSpeer_response (Transact-SQL)
MSpeer_topologyrequest (Transact-SQL)
MSpeer_topologyresponse (Transact-SQL)
MSpub_identity_range (Transact-SQL)
MSpublication_access (Transact-SQL)
MSpublications (Transact-SQL)
MSpublicationthresholds (Transact-SQL)
MSpublisher_databases (Transact-SQL)
MSqreader_agents (Transact-SQL)
MSqreader_history (Transact-SQL)
MSrepl_backup_lsns (Transact-SQL)
MSrepl_commands (Transact-SQL)
MSrepl_errors (Transact-SQL)
MSrepl_identity_range (Transact-SQL)
MSrepl_originators (Transact-SQL)
MSrepl_queuedtraninfo (Transact-SQL)
MSrepl_transactions (Transact-SQL)
MSrepl_version (Transact-SQL)
MSreplication_monitordata (Transact-SQL)
MSreplication_objects (Transact-SQL)
MSreplication_options (Transact-SQL)
MSreplication_queue (Transact-SQL)
MSreplication_subscriptions (Transact-SQL)
MSreplmonthresholdmetrics (Transact-SQL)
MSsnapshot_agents (Transact-SQL)
MSsnapshot_history (Transact-SQL)
MSsnapshotdeliveryprogress (Transact-SQL)
MSsub_identity_range (Transact-SQL)
MSsubscriber_info (Transact-SQL)
MSsubscriber_schedule (Transact-SQL)
MSsubscription_agents (Transact-SQL)
MSsubscription_articles (Transact-SQL)
MSsubscription_properties (Transact-SQL)
MSsubscriptions (Transact-SQL)
MSsync_states (Transact-SQL)
MStracer_history (Transact-SQL)
MStracer_tokens (Transact-SQL)
sysarticlecolumns (Transact-SQL)
sysarticles (Transact-SQL)
sysarticleupdates (Transact-SQL)
sysmergearticlecolumns (Transact-SQL)
sysmergearticles (Transact-SQL)
sysmergepartitioninfo (Transact-SQL)
sysmergepublications (Transact-SQL)
sysmergeschemaarticles (Transact-SQL)
sysmergeschemachange (Transact-SQL)
sysmergesubscriptions (Transact-SQL)
sysmergesubsetfilters (Transact-SQL)
syspublications (Transact-SQL)
sysreplicationalerts (Transact-SQL)
syssubscriptions (Transact-SQL)
sysschemaarticles (Transact-SQL)
Expand Minimize
This topic has not yet been rated - Rate this topic

MSpublication_access (Transact-SQL)

SQL Server 2008

The MSpublication_access table contains a row for each Microsoft SQL Server login that has access to the specific publication or Publisher. This table is stored in the distribution database.

Column name

Data type

Description

publication_id

int

The ID of the publication.

login

sysname

Microsoft Windows accounts that exist at both Publisher and Distributor side.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.