SQL Server 2008 : Deprecated Features

list of deprecated features that are still available.

but will not be in future versions. Remember that while these will still work in SQL Server 2008, they are not a recommended best practice.

1. BACKUP {DATABASE | LOG} WITH PASSWORD

2. BACKUP {DATABASE | LOG} WITH MEDIAPASSWORD

3. RESTORE {DATABASE | LOG} … WITH DBO_ONLY

4. RESTORE {DATABASE | LOG} WITH PASSWORD

5. RESTORE {DATABASE | LOG} WITH MEDIAPASSWORD

6. 80 compatibility level and upgrade from version 80.

7. DATABASEPROPERTY

8. WITH APPEND clause on triggers

9. Default setting of disallow results from triggers option = 0

10. sp_dboption

11. FASTFIRSTROW hint

12. sp_addremotelogin

13. sp_addserver

14. sp_dropremotelogin

15. sp_helpremotelogin

16. sp_remoteoption

17. @@remserver

18. SET REMOTE_PROC_TRANSACTIONS

19. sp_dropalias

20. SET DISABLE_DEF_CNST_CHK

21. SET ROWCOUNT for INSERT, UPDATE, and DELETE

22. statements

23. Use of *= and =*

24. COMPUTE / COMPUTE BY

25. sys.database_principal_aliases

26. sqlmaint Utility

27. The RAISERROR (Format: RAISERROR integer string) syntax