Questions tagged [sp-configure]

In Microsoft SQL Server, it is used to display or change global configuration settings.

Filter by
Sorted by
Tagged with
13
votes
1answer
342 views

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 ...
4
votes
1answer
2k views

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 "...
2
votes
1answer
661 views

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 ...