Blog Archives

SQL Server 2005 replication (Snapshot/Transactions) on different server

Open SQL Server Management Studio Right click on “Replication” & click on Distributor properties Go to publisher tab & Add “SQL Server Publisher” Enter Server Name & Authentication information and click to “Connect” Click on “…” to set the other

Posted in SQL Server

Installation & Configure SQL Server Compact 3.5 SP2 for SQL Server 2012 on Windows 2012

Download Microsoft SQL Server Compact 3.5 Service Pack 2 using below link http://www.microsoft.com/en-sa/download/details.aspx?id=5783 Install both 32-bit and 64-bit versions of Microsoft SQL Server Compact 3.5 Service Pack 2 on a 64-bit Computer Run the Setup Accept License agreement Click “Install”

Posted in SQL Server