SQL Server Faq

Transactional Replication in SQL 2008 Fails “The distribution agent failed to create temporary files in ‘C:Program FilesMicrosoft SQL Server100COM’ directory. System returned errorcode 5.” Tweet

It has been really long time since I have updated this blog as my Job involves a lot of travel however I try my best to update it frequently. In this blog I am going to discuss a issue … Continue reading →

Salient Features of Sql Server 2008 (Katmai) Setup

Minimize the MSI code for setup and use MSI code for what it does the best. In Sql 2005 entire setup process was coded using MSI code which uses the Windows Installer code and was found to be root cause … Continue reading →

BRIEF DESCRIPTION OF KATMAI SETUP PROCESS

In order to install, upgrade, uninstall, and patch the sql server 2008 instance on the system we need to call the setup.exe from the installation media. The setup.exe is an unmanaged code which checks the basic pre-requisites to launch the … Continue reading →