Contents
Where is the publication access list in SQL Server?
Using SQL Server Management Studio. You use the publication access list (PAL) on the Publication Access List page of the Publication Properties – dialog box to manage logins.
How can I add a login to a publication database?
Logins and groups can be added and removed from the PAL. You must associate the SQL Server login with a database user in the publication database before you add the login to the PAL. You use the publication access list (PAL) on the Publication Access List page of the Publication Properties – dialog box to manage logins.
How to remove logins from publication access list?
For more information about how to access this dialog box, see View and Modify Publication Properties. On the Publication Access List page of the Publication Properties – dialog box, use the Add, Remove, and Remove All buttons to add and remove logins and groups from the PAL.
Which is query designer associated with Report Builder?
In Report Builder, the query designer associated with this data extension is the Relational Query Designer. The data source type Microsoft Azure SQL Database wraps and extends the .NET Framework Data Provider for SQL Server.
How to query list of subscriptions and articles?
In Sql Server 2014, how to query a list of Subscriptions & its articles for a given Publication from Publisher? (transactional replication) Yes, there are easier ways to query from Distributor but I need a query from Publisher side. Found this sys proc, not sure if it is correct.
How to manage logins in the publication access list?
To manage logins in the PAL 1 On the Publication Access List page of the Publication Properties – dialog box, use the Add, Remove, and… 2 Click OK. More
How to perform SQL query activity using SOAP API?
This page contains information about performing an SQL query activity using the SOAP API. You can use the SOAP API to perform existing query activities and return any data the activity may return. You must create the query activity in Marketing Cloud before you can use the API to perform the activity.