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.

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.