Some features not supported now in SQL 2005

Category	Discontinued feature	Replacement
Command prompt utilities	Isql	Sqlcmd
Configuration options	‘allow updates’	Option is present but direct updates to system tables are not supported.
Configuration options	‘open objects’	Option has been left in sp_configure to ensure backward compatibility with existing scripts
Configuration options	‘set working set size’	Option is present but it’s functionality has been deactivated.
Database creation	DISK INIT DISK RESIZE	Leagacy behaviour 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
DBCC	DBCC NEWALLOC	DBCC CHECKALLOC
DBCC	DBCC PRINTABLE, DBCC UNPRINTABLE	None.
DBCC	DBCC ROWLOCK	Row-level locking is automatic
DBCC	DBCC TEXTALL DBCC TEXTALLOC	DBCC CHECDB DBCC CHECKTABLE
Network protocols	NWLink IPX/SPX AppleTalk BanyanVines Multiprotocol	TCP/IP sockets Named pipes VIA Shared memory only supported protocols now
Rebuild Master	Rebuildm.exe	Setup.exe
Sample Databases	Northwind pubs	AdventureWorks (Northwind, pubs available by download if necessary)
T-SQL	*=, =* outer join operators	Use JOIN syntax of the FROM clause
Virtual Tables	Syslocks	Sys.dm_tran_locks