Export (0) Print
Expand All

managed_backup.fn_get_parameter (Transact-SQL)

Applies To: SQL Server 2014, SQL Server 2016 Preview

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Returns a table of 0, 1, or more rows of parameter and value pairs.

Use this stored procedure to review all or a specific configuration settings for Smart Admin.

If the parameter has never been configured, the function returns 0 rows.

Applies to: SQL Server (SQL Server 2016 Community Technology Preview 2 (CTP2) through current version).

Topic link icon Transact-SQL Syntax Conventions

managed_backup.fn_get_parameter ('parameter_name' | '' | NULL )

parameter_name

Name of the parameter. parameter_name is NVARCHAR(128). If NULL or an empty string is supplied as an argument to the function, name-values pairs for all configured Smart Admin parameters are returned.

Column Name

Data Type

Description

parameter_name

NVARCHAR(128)

Name of the parameter. The following is a current list of parameters returned:

  • SSMBackup2WANotificationEmailIds

  • SSMBackup2WADebugXevent

  • SSMBackup2WAEnableUserDefinedPolicy

  • FileRetentionDebugXevent

  • StorageOperationDebugXevent

parameter_value

NVARCHAR(128)

Current set value of the parameter.

Permissions

Requires SELECT permissions on the function.

The following example returns all the parameters which have been configured at least once, and their current values.

USE MSDB
GO
SELECT * 
FROM managed_backup.fn_get_parameter (NULL)

The following example returns the email ID specified to receive the error notifications. If no rows are returns, then it means that this email notification option has not been enabled.

USE MSDB
GO
SELECT *
FROM managed_backup.fn_get_parameter ('SSMBackup2WANotficationEmailIds')
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft