:How do I view common parameter values of a RDS SQL Server instance?

Introduction

This topic describes how to view the values of common parameters for RDS SQL Server instances.

 

Background

Alibaba Cloud reminds you that:

• Before you perform operations that may cause risks, such as modifying instance configurations or data, we recommend that you check the disaster recovery and fault tolerance capabilities of the instances to ensure data security.
• You can modify the configurations and data of instances including but not limited to Elastic Compute Service (ECS) and Relational Database Service (RDS) instances. Before the modification, we recommend that you create snapshots or enable RDS log backup.
• If you have authorized or submitted security information such as the logon account and password in the Alibaba Cloud Management console, we recommend that you modify such information in a timely manner.

SQL Server has two system parameter tables, the sys.configurations parameter table of the Server and the sys.databases parameter table of the database. The following example shows how to view the status of Ole Automation Procedures parameters.

1. If you use a client to connect to an instance, see connect to an instance.
2. Click New query SQL window, execute the following command to view the Ole Automation Procedures status

   select * from sys.configurations where name like '%Ole Automation Procedures%'

   A similar output is displayed. The value_in_use parameter is 0, which indicates that the gateway is disabled.
   
   

 

Application scope

• ApsaraDB RDS for SQL Server