catalog-set-customized-logging-level-value.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic
catalog.set_customized_logging_level_value	catalog.set_customized_logging_level_value	chugugrace	chugu	03/14/2017	sql	integration-services	language-reference

catalog.set_customized_logging_level_value

[!INCLUDEsqlserver-ssis]

Changes the statistics or the events logged by an existing customized logging level. For more info about customized logging levels, see Integration Services (SSIS) Logging.

Syntax

catalog.set_customized_logging_level_value [ @level_name = ] level_name  
    , [ @property_name = ] property_name  
    , [ @property_value = ] property_value  

Arguments

[ @level_name = ] level_name
The name of an existing customized logging level.

The level_name is nvarchar(128).

[ @property_name = ] property_name
The name of the property to change. Valid values are PROFILE and EVENTS.

The property_name is nvarchar(128).

[ @property_value = ] property_value
The new value for the specified property of the specified customized logging level.

For a list of valid values for profile and events, see catalog.create_customized_logging_level.

The property_value is a bigint.

Remarks

Return Codes

0 (success)

When the stored procedure fails, it throws an error.

Result Set

None

Permissions

This stored procedure requires one of the following permissions:

• Membership in the ssis_admin database role

• Membership in the sysadmin server role

Errors and Warnings

The following list describes conditions that cause the stored procedure to fail.

• The user does not have the required permissions.