With every version of SQL Server come warnings about features/code that is deprecated. You can use the sys.dm_os_performance_counters dynamic management view to find what these deprecated features are.
If you run the following query on SQL Server Denali CTP 1
select * from sys.dm_os_performance_counters
where object_name like '%deprecated%'
You get back 239 rows, below are the new things compared to 2008
sp_configure ‘awe enabled’
sp_configure ‘affinity64 mask’
sp_configure ‘affinity mask’
SET ERRLVL
SET FMTONLY ON
sp_dropsrvrolemember
sp_addsrvrolemember
sp_droprolemember
sp_addrolemember
sp_changedbowner
DBCC_IND
DBCC_EXTENTINFO
Old NEAR Syntax
NOLOCK or READUNCOMMITTED in UPDATE or DELETE
Take a look at this post Find Out If You Are Using Deprecated Features In SQL Server 2008 if you want the list for SQL Server 2008
Click on the SQL Server Denali tag to see all our SQL Server Denali related posts
Denis has been working with SQL Server since version 6.5. Although he worked as an ASP/JSP/ColdFusion developer before the dot com bust, he has been working exclusively as a database developer/architect since 2002. In addition to English, Denis is also fluent in Croatian and Dutch, but he can curse in many other languages and dialects (just ask the SQL optimizer) He lives in Princeton, NJ with his wife and three kids.
