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 documented process in BOL. How about downgrade...
I found this useful blog SQL Server DTS: Dynamically Change Source and Destination in Transform Data Task that I would like to share the users that are sub-merged with DTS tasks....( read more )