Discontinued Database Engine Functionality in SQL Server 2005
These Database Engine features from earlier versions of SQL Server are not supported in SQL Server 2005.
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
Use the sqlcmd utility.
sqlcmd and osql utilities do not support the passing of stored procedure return values to the exit value.
For more information, see sqlcmd Utility.
'allow updates' option of sp_configure.
Option is present but direct updates to system tables are not supported
'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.
'set working set size' option of sp_configure
Option is present but its functionality has been deactivated.
Legacy behavior from SQL Server 6.x
FOR LOAD option of CREATE DATABASE
RESTORE operations can create a database
Use DROP DATABASE to remove a damaged database.
For more information, see DROP DATABASE (Transact-SQL).
For more information, see DBCC (Transact-SQL).
DBCC PINTABLE, DBCC UNPINTABLE
Row-level locking is automatic.
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.
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.
Use the REBUILDDATABASE option in Setup.exe.
For more information, see How to: Install SQL Server 2005 from the Command Prompt.
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.
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.
SQL-DMO based WMI provider
Managed code: Microsoft.SqlServer.Management.Smo.Wmi
Non-managed code: WMI Provider for Configuration Management
SQL Namespace API (SQL-NS)
*= and =* outer join operators
Use the JOIN syntax of the FROM clause.
For more information, see FROM (Transact-SQL).
For more information, see sys.dm_tran_locks.