Monthly Archives: October 2009

Creating Maintenance Plan with Maintenance Plan Wizard in SQL Server 2005

Posted on October 30, 2009 by

In this post, we will discuss how to create Maintenance plan in SQL Server 2005. The environment is having SQL Server 2005 SP3 installed. Before creating the maintenance plan in the lab environment, let’s see our requirement. Maintenance Plan Details … Continue reading →

Posted in Automation in SQL Server | Leave a comment

How to Transfer Logins from one SQL server instance to another SQL Server instance?

Posted on October 22, 2009 by

It is one of the common question, which we can expect during any SQL Server interview: “How should you transfer logins from one instance of SQL Server to another?” The answer is pretty simple, however, its very complicated as well. … Continue reading →

Posted in Security in SQL Server | 6 Comments

Dedicated to My Father

Posted on October 20, 2009 by

My father, Late Mr. Uttam Kumar Ganguly, was a System Administrator with State Bank of India. This blog is my tribute to my father……

Posted in Personal | Leave a comment