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:

Improvement & Optimization

1.Treat data quality as a business problem. CIOs must not take ownership of the data cleansing initiative. Instead, they need to convince their C-level colleagues to place responsibility for data quality where it really belongs - in the business.

Hi,

I am developing a Web site with Asp.Net 3.5 and SQL Server 2005 and also using LINQ. I have been Migrated my database from SQL server 2000 to SQL Server 2005.
I am getting below error randomly :
Server failed to resume the transaction, desc: 3400000003.

Can you please provide me any solution for this

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)