SQL-Articles

Author: Deepak

  • How to Recover SA password when you forget it – SQL 2005

    What to do if you forgot SA password in SQL Server 2005? In general if you forgot SA password or if the SA account is disabled these are the options to login into SQL Server 2005 and reset or enable SA.

  • Transactional Replication

    This article teaches you how to set up transactional replication using wizards and scripts. In most cases, youll set up the initial publication and subscribers using wizards; however, if you need to apply the same publication in multiple environments, youll appreciate the option of applying the scripts as opposed to going through wizards time and…

  • Transactional Replication – Configure Subscriber

    Unlike previous versions, of SQL Server 2005 allows you to use the same wizard to create either pull or push subscriptions. Perform the below steps to Configure Subscriber

  • Transactional Replication – Configure Publication

    Once youve configured a distributor, youre ready to create publications. Perform the below steps as follows, Step1 : Connect to an instance (Sansu) of SQL Server by using the SQL Server Management Studio (SSMS), navigate to the “replication” folder then local publications folder, right-click this folder, and select New Publication. This invokes the new publication…

  • Transactional Replication – Configuring Distributor

    Lets Discuss the steps to Configure Distributor in detail. In this article I am using the Server SansuTest as the Distributor. The Distributor is configured from SSMS as follows :