Deprecated Database Engine Features in SQL Server 2005

Often while upgrading to SQL Server 2005 from the earlier version of SQL Server, you might come across a situation where some of the features are deprecated or not supported. So here is the list of deprecated Database Engine Features in SQL Server 2005

http://msdn.microsoft.com/en-us/library/ms143729(SQL.90).aspx

Happy Learning !!!

Support for DTS in SQL Server 2008

As we all know that SQL Server 2000 Data Transformation Services is already deprecated but SQL Server 2008 still supports DTS (Limited Functionality). SQL Server 2008 provides optional 32 bit management, run-time, and design-time support for packages that were created by using the DTS tools and object model.

Note:

1. Please note that not all the functionality of DTS is supported in SQL Server 2008.
2. To get the DTS support in SQL Server 2008 you might have to manually install additional, optional components that are not available during setup.

For more information on which are the functionalities of DTS is supported in SQL Server 2008, please visit the below link

http://msdn.microsoft.com/en-us/library/bb500440(v=SQL.105).aspx

Happy Learning !!!