Questions tagged [sp-configure]
In Microsoft SQL Server, it is used to display or change global configuration settings.
3
questions
13
votes
1answer
488 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 ...
5
votes
1answer
4k 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
990 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 ...