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…