Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

There are two types of subscriptions in SQL Server replication. What are they?

April 26, 2017replication SQL Server subscriptions types

0

Posted

There are two types of subscriptions in SQL Server replication. What are they?

1 Answer

0

Posted

Push/Pull The two types of subscriptions are push and pull. What is the scope of the control permission in SQL Server 2005? It allows the grantee the equivalent of ownership in that they have all permissions and can grant them to others. The Control permission is equivalent to assigning ownership of the securables. All available permissions are granted to the principal, and they the principal in turn can grant those permissions to others. When testing connectivity in SQL Server, you use which utility in conjunction with the readpipe utility to establish a connection? makepipe The makepipe utility is used with the readpipe utility to test connectivity only for named pipes connections. This utility has been deprecated in SQL Server 2005. In replication, what is each set of the source data that is replicated from the source server called? Article Each set of source data that is replicated is called an article. In SSIS, what is the difference between output columns and external columns? Ex