Discontinued Database Engine Functionality in SQL Server 2005

Category	Discontinued feature	Replacement
Backup and restore	Named pipe backup devices.	Disk or tape devices. For security reasons, SQL Server does not support backup to named pipes.
Command prompt utilities	isql utility	Use the sqlcmd utility. Note: sqlcmd and osql utilities do not support the passing of stored procedure return values to the exit value. For more information, see sqlcmd Utility.
Configuration options	'allow updates' option of sp_configure.	Option is present but direct updates to system tables are not supported
Configuration options	'open objects' option of sp_configure.	Option is present but its functionality has been deactivated. In SQL Server 2005, the number of open database objects is managed dynamically and is only limited by available memory. The 'open objects' option has been left in sp_configure to ensure backward compatibility with existing scripts.
Configuration options	'set working set size' option of sp_configure	Option is present but its functionality has been deactivated.
Database creation	DISK INIT DISK RESIZE	Legacy behavior from SQL Server 6.x
Database creation	FOR LOAD option of CREATE DATABASE	RESTORE operations can create a database
DBCC	DBCC DBREPAIR	Use DROP DATABASE to remove a damaged database. For more information, see DROP DATABASE (Transact-SQL).
DBCC	DBCC NEWALLOC	DBCC CHECKALLOC For more information, see DBCC (Transact-SQL).
DBCC	DBCC PINTABLE, DBCC UNPINTABLE	None.
DBCC	DBCC ROWLOCK	Row-level locking is automatic.
DBCC	DBCC TEXTALL DBCC TEXTALLOC	DBCC CHECKDB DBCC CHECKTABLE
Extended store procedure programming	Use of SRV_PWD field in the SRV_PFIELD structure when there has been an impersonation context switch from the original login.	None.
Network protocols	The following protocols: NWLink IPX/SPX, AppleTalk, Banyan Vines, Multiprotocol.	Configure your application and the instance of the Database Engine to use one of the supported protocols: TCP/IP sockets, named pipes, VIA, or shared memory. For more information, see Choosing a Network Protocol.
Rebuild master	Rebuildm.exe	Use the REBUILDDATABASE option in Setup.exe. For more information, see How to: Install SQL Server 2005 from the Command Prompt.
Sample databases	Northwind and pubs	Use AdventureWorks; however, Northwind and pubs are available as downloads, or can be copied from a previous installation of SQL Server. For more information, see Samples and Sample Databases.
Setup.exe	Remote Setup - the TARGETCOMPUTER parameter - is not supported.	Use a remote connection to run the SQL Server Setup program in user interface mode or from the command prompt.
APIs	SQL-DMO based WMI provider	Managed code: Microsoft.SqlServer.Management.Smo.Wmi Non-managed code: WMI Provider for Configuration Management
APIs	SQL Namespace API (SQL-NS)	None
Transact-SQL	*= and =* outer join operators	Use the JOIN syntax of the FROM clause. For more information, see FROM (Transact-SQL).
Virtual tables	syslocks	sys.dm_tran_locks For more information, see sys.dm_tran_locks.