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