Deprecated Features in SQL Server 2012 Denali

Deprecated Features in SQL Server 2012 Denali


1. Old style join are no more supported like *= and =*

2. Compute and Compute by are no more supported

3. Added Restriction in Usage of Raiserror

RAISERROR in the format RAISERROR integer 'string' is discontinued

4. Fastfirstrow query hint is no more supported

5. Databaseproperty function is no more supported

6. 32-bit Address Windowing Extensions (AWE) and 32-bit Hot Add memory support are discontinued

7. SQL Mail is no more supported

8. sp_dboption is no more supported

9. with append clause on trigger is no more supported

10. I. sp_configure 'user instance timeout'

II. sp_configure 'user instances enabled'

11. 80 Compatibility level is not supported

12. 1. RESTORE DATABASE WITH DBO_ONLY

2. RESTORE LOG WITH DBO_ONLY

13. The Active Directory Helper service and the related components has been removed

sp_ActiveDirectory_Obj

sp_ActiveDirectory_SCP

sp_ActiveDirectory_Start



14. SQL Server 2012 Denali does not support SQL Server Distributed Management Objects (SQL-DMO) any more. SQL Server Management Objects (SMO) is the recommended alternative

15. SQL Server 2012 (Denali) no more supports the following backup commands.

BACKUP DATABASE WITH PASSWORD

BACKUP LOG WITH PASSWORD

BACKUP DATABASE WITH MEDIAPASSWORD

BACKUP LOG WITH MEDIAPASSWORD

16. SQL Server 2012 Denali does not support VIA protocol any more

Use TCP instead of VIA protocol

17. The ability for users to create new remote servers by using sp_addserver is discontinued. sp_addserver with the 'local' option remains available. Remote servers preserved during upgrade or created by replication can be used

18. sp_dropalias

19. The version parameter of PWDCOMPARE representing a value from a login earlier than SQL Server 2000 is discontinued

20. System table sys.database_principal_aliases is no more available

21. Xevent

databases_data_file_size_changed, databases_log_file_size_changed

eventdatabases_log_file_used_size_changed

locks_lock_timeouts_greater_than_0

locks_lock_timeouts

22. Set Options SET DISABLE_DEF_CNST_CHK is no more available

23. Data types text ,ntext,Image are no more avaiableData types



Data Transformation Services (DTS)

Support for migrating or running Data Transformation Services (DTS) packages has been discontinued in this release. The following DTS functionality has been discontinued.

• DTS runtime

• DTS API

• Package Migration Wizard for migrating DTS packages to the next version of Integration Services

• Support for DTS package maintenance in SQL Server Management Studio

• Execute DTS 2000 Package task

• Upgrade Advisor scan of DTS packages.

Execute DTS 2000 Package Task

The Execute DTS 2000 Package task has been discontinued.



To know the details about depreciated features in SQL Server 2012 Denli

Check below link:

http://msdn.microsoft.com/en-us/library/ms143729(v=sql.110).aspx