SQLAuthority News – Bookmark – Deprecated Database Engine Features in SQL Server 2008

When anyone asked me if any specific feature is available in SQL Server 2008 or if any feature will be disabled in future versions of SQL Server, I always pointed to the following list where all the deprecated database engine features are listed.

Deprecated Database Engine Features in SQL Server 2008 R2

Deprecated Database Engine Features in SQL Server 2008

This list is quite helpful and everybody should refer it once. This list has many important details. For example, it suggests “80 compatibility level and upgrade from version 80.” will not be supported in next version of SQL Server. If you are using SQL Server 2000 even today (by any chance), you will be not able to upgrade that to the next version of SQL Server directly.

It is very important to check if you are using any feature of SQL Server that is in compatibility mode and if you find them in the list above, you need to start working on the replacement suggested in article.

Reference: Pinal Dave (http://blog.SQLAuthority.com)

About these ads

4 thoughts on “SQLAuthority News – Bookmark – Deprecated Database Engine Features in SQL Server 2008

  1. After upgrdation to sql 2008 from sql 200, if the compatibility level is set to 80, will the queries that use the deprecated system tables and other deprecated features still work fine?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s