Export (0) Print
Expand All

smart_admin.fn_get_parameter (Transact-SQL)

SQL Server 2014

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 2014 through current version).

Topic link icon Transact-SQL Syntax Conventions

smart_admin.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 smart_admin.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 smart_admin.fn_get_parameter ('SSMBackup2WANotficationEmailIds')
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft