Input Data: [crayon-5d6b62efdd6d2217933818/] Expected Output: [crayon-5d6b62efdd6de369842994/] Create a table with sample data: [crayon-5d6b62efdd6e2730974460/] Solution 1: Using CTE [crayon-5d6b62efdd6e5917488241/] Solution 2: Using GROUP BY ..
Having [crayon-5d6b62efdd6e8426617712/] Please […] I'm Anvesh Patel, a Database Engineer certified by Oracle and IBM.
Select “Run under the SQL Server Agent service account” Select “Using the following SQL Server login” and provides the credentials. Creating Subscriber After the creation of publisher the next step is to create the subscriber for it. Step5: Choose subscribers and specify each subscriptions database.
The steps to create subscriber are given bellow: Step1: Right click on created publisher and select New Subscriptions. We can use same or remote SQL server as subscriber. In the subscriber list the default server is local.
Some key points of transactional replication with updatable subscriptions are given bellow: Configuring Distribution At first we need to configure a distributor database which manages the total replication process.