Important deprecated features of SQL server 2017



I was going through list of deprecated features/syntax and I am sure in all projects we are using atleast some of the below features/syntax which might break after upgrade.


  • RESTORE and BACKUP database WITH PASSWORD
  • Ability to return result set from triggers
  • SET ROWCOUNT for INSERT, UPDATE and DELETE
  • SET ANSI NULLS OFF
  • Ability to insert null values into timestamp columns
  • TEXT, NTEXT and IMAGE datatypes 
  • CREATE TABLE, ALTER TABLE or CREATE INDEX syntax without parenthesis around the option
  • Lot of options of procedure sp_configure 
  • Specifying the SQLOLEDB provider for linked servers
  • USER_ID function 
  • Specifying NOLOCK or READUNCOMMITTED in the FROM clause of an UPDATE or DELETE statement.
  • Specifying table hints without using the WITH keyword.
  • Three-part and four-part column references.
  • A string enclosed in quotation marks used as a column alias for an expression in a SELECT list:
    'string_alias' = expression
  • SQL Server Profiler for Trace Capture
  • Lot of system tables and system stored procedure like sysindexes 


Source: Microsoft




No comments:

Powered by Blogger.