Wednesday, June 07, 2006

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

No comments: