Validate sql script before deployment

As a DBA, you've been asked to validate/verify SQL script and seee if it's working as expected before deployment. we can verify into development server but there is one more option which we can use for script validation

Use SET  NOEXEC ON before and SET NOEXEC OFF after script. once you'll execute it will only create compilation plan for SQL script but it will not make any update/changes into data table.

--verify SQL script

SET NOEXEC ON

--your SQL script

SET NOEXEC OFF

Add caption