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

T-SQL
1
2
select * from sys.dm_os_performance_counters
where object_name like '%deprecated%'
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