Sample Header Ad - 728x90

Are harmless sp_configure commands always safe to run?

2 votes
1 answer
77 views
Suppose that I wish to run the following
/* Check for any pending configurations, just in case. */
SELECT *
FROM sys.configurations
WHERE value  value_in_use;
GO
 
EXEC sp_configure 'remote admin connections', 1;
GO
RECONFIGURE
GO
Is there any risk, such as clearing the plan cache or blocking queries, to running this during a busy day? I know that the remote admin connection is safe. I'm concerned about sp_configure.
Asked by J. Mini (1237 rep)
Jun 20, 2025, 06:37 AM
Last activity: Jun 20, 2025, 02:30 PM