My first ever post was about the features in SQL Server 2000 that were deprecated in SQL Server 2005 i.e. they wouldn’t be available in the next release (SQL Server 2008). In the same way there are SQL Server 2005 features that will be deprecated in SQL Server 2008, they will still work and be supported, but won’t be available in the next release of SQL Server.

The links for all of deprecated features for the different parts of SQL Server are below:

  • Database Engine

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

  • Replication

http://msdn.microsoft.com/en-us/library/ms143550(SQL.100).aspx

  • Integration Services

http://technet.microsoft.com/en-us/library/ms403408(SQL.100).aspx

  • Analysis Services

http://technet.microsoft.com/en-us/library/ms143346(SQL.100).aspx

  • Reporting Services (No features deprecated)

http://technet.microsoft.com/en-us/library/ms143509(SQL.100).aspx

So please consider these articles when doing development on SQL Server to avoid pianting yourself into a corner in a few years time.