Browse by Tags

Downgrade or revert or restore SQL Server 2005 database to SQL Server 2000 version

Published 20 July 7 3:21 AM | SSQA.net

Can somebody tell me, it is possible to convert a database developed in sql2005 back to sql2000? A common question now a days in the forums and newsgroups, as you are aware UPGRADE process is available to enhance SQL 2000 database to SQL 2005 as per the...

Filed under: sql server, ssms, database, upgrade, dts, management studio, degrade

A Guided Tour to SQL Server Integration Services (SSIS)

Published 16 July 7 8:2 AM | SSQA.net

I have been asked many of our developers and even got through few questions asking about how to understand SQL Server Integration Services which is a traditional extract methods with a transform, and load (or ETL) model of integrating data from standard...

Filed under: sql server, ssis, ssas, ssms, dts, etl, tour