none
Changing DataBase from sql server 2008R2 to 2016

    Question

  • Hello

            There are some features that are deprecated in sql server and are mentioned in Microsoft site but when i use it in both versions it parses in both , i have a question that if i have to change them  or not , is then any problem when i change the version  and the capabability of DB ?? bellow are the features that is used in sqlserver 2008r2.

    DBCC DBREINDEX
    DBCC SHOWCONTIG
    CREATE TABLE, ALTER TABLE, or CREATE INDEX syntax without parentheses around the options.
    SET FMTONLY

    please if there is help me with a  replacment .

    artinl

     
    • Moved by Tom Phillips Tuesday, January 31, 2017 2:01 PM Upgrade question
    Tuesday, January 31, 2017 12:49 PM

Answers

All replies