RSS

Monthly Archives: January 2013

Creating Database with Different Collation on Server

 
Leave a comment

Posted by on January 13, 2013 in General topics

 

Default Collation of SQL Server 2008

 
Leave a comment

Posted by on January 13, 2013 in General topics

 

Change Collation of Database Column – T-SQL Script

 
Leave a comment

Posted by on January 13, 2013 in General topics

 

SQL SERVER – 2005 – Find Database Collation Using T-SQL and SSMS

 
1 Comment

Posted by on January 13, 2013 in General topics

 

 
Leave a comment

Posted by on January 13, 2013 in General topics

 

Disable Publishing and Distribution Servers

1- Open MSSQL Distribution Server >>> mangment Studio >>> Replication >>> Write Click >>>> Disable Publishing and Distribution

Disable PDisable ublishing and Distribution

2- Disable this  Distribution and Publishing in this Server or Disable the Publishing and let the Distribution

Replic_5

3- Confirm Disabling Remote publisher this step if you add Remote Publisher

Confirm Remote Publisher

4- Confirm Disable is Wizerd or T-SQL

Replic_7

Now if you Checked the Distrubiter Database under the System Database you will not Found it also if you make write Clikc on Replication you will See Configure Distribution option that’s meaning this server without Distribution

Check

Wait for me in another Replication posts

Regards ,

Mostafa Elmasry

 
Leave a comment

Posted by on January 5, 2013 in Replication

 

How to Add New Publisher Server to the Distributor Server (MSSQL Replication)

now if i need to Add new Publisher on my Distributor Server i will do this steps in SQL Server Also if you need to know hot to Setup the Cnfiguration of Distributor Server see this link :http://wp.me/p1Oidq-et or Check the replication categories :https://mostafaelmasry.wordpress.com/category/sql-server-2008/replication/

1- Connect to the MSSQL Distributor Server >>> mangement Studio >>> Replication >>> Write Click >>> Distributor properties

Replic_1

2- Add SQL publisher

Add SQL publisher

3- Add password to Connect the Publisher with this password to the Distributor

replic_3

Now if you Check the Distributor Server you will See 2 Publisher Server

Wait for me in another Replication posts

Regards ,

Mostafa Elmasry

 

 
Leave a comment

Posted by on January 5, 2013 in Replication

 

Tags: , ,