How to uninstall HOTFIXES manually when the base SQL 2000 is not there in the box

Consider a scenario where SQL 2000 has been uninstalled and Hotfixes are still visible. In my case it was hotfix 2050 and 2273. One will find the hotfix components visible in the ADD\REMOVE program. In that scenario attempts of removing the hotfixes are unsuccessful from the ADD\REMOVE programs. Attempts of removing the same from C:\Winnt\–>Uninstall…

3

How to setup a SQL Server Replication between three servers in a typical scenario..

Three Servers (Top, middle and Bottom) Data will flow from Top to the Bottom Server. Top to Middle Server (one way Replication) and Middle to Last Server (two ways Replication).   =================================================                                                  —->Top Server—-> Middle Server         Last Server                                                  <—- ==================================================   In order to get this replication topology done, we can use…

1

Step by Step Procedure to Implement SQL Server Transactional Replication with Oracle as Publisher

/*** Note: Kindly follow the Instruction in each step ***/ /*** If you are using SQL Server 2008 Management Studio, Ctrl-Shift-M might not work. In that case go to “Query” menu and click on “Specify Values for Template Parameters” ***/ 1) Logon to ORACLE database as SYSDBA and follow the below steps a) Create Tablespace…

4