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
Last activity: Jun 20, 2025, 02:30 PM