In Microsoft SQL Server, it is used to display or change global configuration settings.
Use sp_configure to display or change server-level settings.
References - sp_configure (Transact-SQL)
Questions tagged [sp-configure]
5 questions
13
votes
1 answer
SET NOCOUNT Error in handling SQL call after upgrade
We are upgrading our test environment with a new server and updated version of Microsoft SQL Server and have run into an issue.
On the new server, our old code will get "operation is not allowed when the object is closed" when executing some stored…
UnhandledExcepSean
- 333
- 3
- 9
6
votes
1 answer
What does 'sp_configure allow updates' do?
Today I got an error ( DTSER_FAILURE ) but I could fix it by editing the maintenance plan ( this error is due to the maintenance plan searching for a database that was deleted, and I was using "selected databases" in the setup ).
But over the…
Racer SQL
- 7,546
- 16
- 77
- 140
2
votes
1 answer
Are harmless sp_configure commands always safe to run?
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…
J. Mini
- 1,161
- 8
- 32
2
votes
1 answer
how to temporarily change the sql server settings in order to do a task and when finished revert back?
when I run the script below all at once I get this error message:
Msg 15281, Level 16, State 1, Line 58 SQL Server blocked access to
STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed
Queries' because this component is…
Marcello Miorelli
- 17,274
- 53
- 180
- 320
0
votes
2 answers
How to avoid writing to the error log when changing instance configuration?
If you look at how to temporarily change the sql server settings in order to do a task and when finished revert back? there is a way to save SQL Server settings before enabling them, so you can disable them if needs be.
Here is the code (partially…
Marcello Miorelli
- 17,274
- 53
- 180
- 320