Create publication on your default instance of sql server


Problem

1. Create a publication on your default instance of SQL server that creates a transactional snapshot of the SUPPLIERS and PRODUCTS tables located in the Northwind database.

a. Only publish the ProductID, ProductName, UnitPrice, UnitsInStock columns from PRODUCTS

2. Set up this publication to push the table to a subscription on Instance2. The target database should be called NWindSupplierslocated on the second instance.

3. E-mail a screenshot of the Publication and Subscription. Screenshot the Replication Manager status showing a successful replication.

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Create publication on your default instance of sql server
Reference No:- TGS02746751

Expected delivery within 24 Hours