In Previous three parts I have explained about
Many time it happens that you get a call from your friend or family member or from a customer asking about a problem they are facing on their computer and they want to fix it. This post tell you that how you can fix such problems using Google Chrome Remote Desktop extension.
Replication is can be defined as a process of copying or reproducing information between two or more resources to improve reliability, fault-tolerance or accessibility. Replication can be configured on LAN, WAN or on Internet for database where same data is copied and stored on multiple database servers or for web services where website data is distributed on various locations to increase the availability of website/database in case of any failure at one location.
Everyone wants the fastest broadband service using the best provider. To get the best deal, consumers need to shop around, making sure that they are comparing multiple companies and all of the different products and services they offer. It is also important to check the rates and speeds, packages or bundles and read reviews written by other customers.
You have prepared a Word Document it might be anything a proposal, quotation, or any writeup for your company and sent it to your seniors for review. They review it and send the updated one to you but now you want to findout the changes or modification they have made OR you are running a Software development company and Business Analyists keep updating documents and you need to find the changes or modification they have made.
After you configure the Distributor Server (Guide to MS SQL 2008 Transactional Replication (Configure Distributor) Part-II) now I will explain how you can create & configure the Publisher.
Few days ago while working on MS SQL 2008 Transactional Replication I have faced following two issue
1) To find out the total number of tables to verify that Primary Server and Secondary server have same table count.
2) Tables without Primary key: After replication setup I have found that some tables were not replication. When I checked the logs it showed following error