Compatibility levels

Replace remote servers by using linked servers.

Deprecated feature

Replacement

Feature name

Feature

Replace remote servers by using linked servers.

can only be used with the local option.

@@remserver

Replace remote servers by using linked servers.

None

Replace remote servers by using linked servers.

110

Deprecated feature

Replacement

Feature name

Feature

for

, and

statements

keyword

109

HOLDLOCK table hint without parenthesis.

Use HOLDLOCK with

parenthesis.

HOLDLOCK table hint without

parenthesis

167

The following SQL Server Database Engine features are supported in the next version of SQL Server. The specific version of

hasn’t been determined.

Deprecated feature

Replacement

Feature name

BACKUP { DATABASE | LOG } TO TAPE

BACKUP { DATABASE | LOG } TO

device_that_is_a_tape

BACKUP { DATABASE | LOG } TO DISK

BACKUP { DATABASE | LOG } TO

device_that_is_a_disk

BACKUP DATABASE or LOG TO

TAPE

ﾉ

Expand table

ﾉ

Expand table

ﾉ

Expand table

ﾉ

Expand table

sp_addremotelogin sp_addserver sp_dropremotelogin sp_helpremotelogin sp_remoteoption

sp_addserver

sp_addremotelogin sp_addserver sp_dropremotelogin sp_helpremotelogin sp_remoteoption

SET
REMOTE_PROC_TRANSACTIONS

SET
REMOTE_PROC_TRANSACTIONS

SET ROWCOUNT

INSERT

UPDATE

DELETE

TOP

SET ROWCOUNT

sp_addumpdevice 'tape'
sp_addumpdevice 'disk'
ADDING TAPE DEVICE sp_helpdevice sys.backup_devices sp_helpdevice