The Data Warehouse Business Plan will help you establish a clear scope and direction for your data warehouse (DW) program, as well as identify potential pitfalls and risks.

The steps that are outlined in the business plan can be broadly categorized as:

Info-Tech analysts are frequently asked a seemingly simple question: “Should we deploy a data warehouse before our BI initiative or should we wait?” While the question is simple, the answer is not. Info-Tech's guidelines assist decision makers through this challenge.

How will I check if SQL Server 2005 SP2 is installed?

How to tell if SQL 2005 SP2 is installed?

To see if SQL 2005 Service Pack 2 is installed execute the following command:

Select @@version

This query should come up with something like this:

Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)   Feb  9 2007 22:47:07   Copyright (c) 1988-2005 Microsoft Corporation  Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2)