Create transactional publication in sql server 2008

Hi all,
Today we are going to learn how to create a transactional publication in sql server 2008. You may create it by using gui of sql server management studio. But we learn using sql script. Just copy the following code and enjoy…

Removing Distribution From Sql Server

Hello all,
Today we learn how to remove distribution database from your sql server.
Dont try to delete the distribution server directly. If you delete the distribution database, its actually not deleted, then you have to reinstall the sql server. So, to avoid this mess up please copy the following script and run in your sql server…

Configure Distribution server for Replication in Sql server 2008

Hi all,

Today we are going to learn how to make a distribution server for replication in sql server 2008.
Many people configure the distribution server using gui(graphical user interface).
But, i am comfortable with the sql server script. So, we learn how to make a sql server applicable for distribution using sql script.

At, first connect to sql server 2008 instances and then create a new query and copy the following code…