Whether anonymous subscriptions are allowed on the publication. Whether pull subscriptions are allowed on the publication. Whether push subscriptions are allowed on the publication. Whether the synchronization files for the publication are exposed to the Internet, through file transfer protocol (FTP) and other services. Whether the synchronization files are created or re-created each time the Snapshot Agent runs. Optional description for the publication. Future compatibility is not guaranteed.Ġ = Native bulk copy program ( bcp utility)ģ = Concurrent, which means that native bulk copy ( bcputility) is used but tables are not locked during the snapshotĤ = Concurrent_c, which means that character bulk copy is used but tables are not locked during the snapshot Identified for informational purposes only. Publisher should not be specified when requesting publication information from a SQL Server Publisher.
publisher is sysname, with a default of NULL. 0 indicates the publication is not found. foundis int and an OUTPUT parameter, with a default of 23456. publication is sysname, with a default of %, which returns information about all publications. Is the name of the publication to be viewed. For an Oracle publication, this stored procedure is executed at the Distributor on any database. For a Microsoft SQL Server publication, this stored procedure is executed at the Publisher on the publication database. Applies to: SQL Server (all supported versions) Azure SQL Managed Instance
0 kommentar(er)
