Discontinued Database Engine Functionality in SQL Server 2008 R2
Notes
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 AdventureWorks 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. |