MSpublication_access (Transact-SQL)

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.

See Also

Reference

Mapping SQL Server 2000 System Tables to SQL Server 2005 System Views

Other Resources

Integration Services Tables
Backup and Restore Tables
Log Shipping Tables

Help and Information

Getting SQL Server 2005 Assistance