Discontinued Database Engine Functionality in SQL Server 2008 R2
 Note |
|---|
For SQL Server 2008 R2, there have been no changes to the content that is listed in this topic. |
This topic describes the Database Engine features that are no longer available in SQL Server 2008.
Category | Discontinued feature | Replacement |
|---|---|---|
Aliases | sp_addalias | Replace aliases with a combination of user accounts and database roles. For more information, see CREATE USER (Transact-SQL) and CREATE ROLE (Transact-SQL). Remove aliases in upgraded databases by using sp_dropalias. |
APIs | Registered Servers API | Replaced by a new registered servers API that supports new SQL Server 2008 features. |
Backup and restore | DUMP statement | BACKUP |
Backup and restore | LOAD statement | RESTORE |
Backup and restore | BACKUP LOG WITH NO_LOG | None. The transaction log is automatically truncated when the database is using the simple recovery model. If you must remove the log backup chain from a database, switch to the simple recovery model. |
Backup and restore | BACKUP LOG WITH TRUNCATE_ONLY | None. The transaction log is automatically truncated when the database is using the simple recovery model. If you must remove the log backup chain from a database, switch to the simple recovery model. |
Backup and restore | BACKUP TRANSACTION | BACKUP LOG |
Compatibility level | 60, 65, and 70 compatibility levels | Databases must be set to at least compatibility level 80. |
DBCC | DBCC CONCURRENCYVIOLATION | None |
Groups | sp_addgroup | Use roles. |
Groups | sp_changegroup | Use roles. |
Groups | sp_dropgroup | Use roles. |
Groups | sp_helpgroup | Use roles. |
Sample databases | Northwind and pubs | Use AdventureWorks2008R2. Northwind and pubs are available as downloads, or can be copied from a previous installation of SQL Server. For more information, see AdventureWorks2008R2 Sample Databases. |
Tools | Surface Area Configuration Tool | The Surface Area Configuration Tool is discontinued for SQL Server 2008. For more information, see Backward Compatibility. |
Web Assistant | sp_makewebtask sp_dropwebtask sp_runwebtask sp_enumcodepages | We recommend that you use SQL Server Reporting Services instead. |
