Updating catalogs backup exec 2016
To execute sp_configure with both parameters to change a configuration option or to run the RECONFIGURE statement, you must be granted the ALTER SETTINGS server-level permission.
The ALTER SETTINGS permission is implicitly held by the sysadmin and serveradmin fixed server roles.
By default, these options are not available for viewing and changing.
To make them available, set the Show Advanced Options configuration option to 1.
Use sp_configure to display or change server-level settings.Important On Azure SQL Database Managed Instance, this T-SQL feature has certain behavior changes.See Azure SQL Database Managed Instance T-SQL differences from SQL Server for details for all T-SQL behavior changes.-- Syntax for Parallel Data Warehouse -- List all of the configuration options sp_configure [;] -- Configure Hadoop connectivity sp_configure [ @configname= ] 'hadoop connectivity', [ @configvalue = ] [;] RECONFIGURE [;] is varchar(35), with a default of NULL.The SQL Server Database Engine recognizes any unique string that is part of the configuration name.