We are trying to execute the below statement in Azure SQL Database. Is there any workaround this or equivalent query for Azure SQL Database.
EXEC sp_configure 'show advanced options',1
RECONFIGURE WITH OVERRIDE
EXEC sp_configure 'max text repl size (B)', -1
RECONFIGURE WITH OVERRIDE
EXEC sp_configure 'show advanced options',0
RECONFIGURE WITH OVERRIDE
can this bet set or changed from Azure portal? Any help will be appreciated. Thanks a lot :)
CodePudding user response:
No, you can't configure the max text repl size Server Configuration using Azure portal because these settings can only be set by the user who has required permission. Therefore, user with permission can only configure using T-SQL commands.
Execute permissions on sp_configure with no parameters or with only the first parameter are granted to all users by default. To execute sp_configure with both parameters to change a configuration option or to run the RECONFIGURE statement, a user must be granted the ALTER SETTINGS server-level permission. The ALTER SETTINGS permission is implicitly held by the sysadmin and serveradmin fixed server roles.
Refer: Configure the max text repl size Server Configuration Option
CodePudding user response:
Is this supported on azure sql db? Or what is the workaround.