find deprecated or reserved keywords in SQL Script.

• DBA

  Old Hand

  Points: 371

  More actions

  September 23, 2022 at 7:26 pm

  #4091336

  Hello,

  How to catch/find deprecated or reserved keywords being used in specific or single SQL script during code review shared by developers?

  Sometimes it is difficult to remember so any advice would be helpful!

  Secondly, there are many articles online about general SQL Code review tips. However please share, if any good ones you are aware of or tips which helped you to not miss errors or issues in script.

  Thanks.

• Jeffrey Williams

  SSC Guru

  Points: 90350

  More actions

  September 23, 2022 at 8:30 pm

  #4091354

  Have you looked at this: https://learn.microsoft.com/en-us/sql/database-engine/install-windows/prepare-for-upgrade-by-running-data-migration-assistant?view=sql-server-ver16

   

  Jeffrey Williams
  “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

  ― Charles R. Swindoll

  How to post questions to get better answers faster
  Managing Transaction Logs