More and more of the old commands are being deprecated as SQL moves forward with integrating these more into standard T-SQL commands.
Some commands which were marked as not supported in a future version of SQL Server in 2008 R2 are still here in SQL 2012. The often used sp_attach_db and sp_renamedb are two in the list. Also the well used DBCC DBREINDEX and DBCC INDEXDEFRAG are also on the list. Some of these commands are used commonly in day to day use, some as part of older routines.
Deprecated commands in SQL Server 2012