Articles → SQL SERVER → set noexec statement in SQL server

set noexec statement in SQL server






Purpose





Example




Set noexec on

-- This query will not execute as noexec is set to "On"
select top 5 * from sys.procedures

Set noexec off

-- This query will execute as noexec is set to "Off"
select top 5 * from sys.objects





Output


Picture showing the output of the set noexec statement in SQL server

Click to Enlarge


Posted By  -  Karan Gupta
 
Posted On  -  Saturday, June 5, 2021

Query/Feedback


Your Email Id  
 
Subject 
 
Query/FeedbackCharacters remaining 250