title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
---|---|---|---|---|---|---|---|
catalog.set_folder_description (SSISDB Database) |
catalog.set_folder_description (SSISDB Database) |
chugugrace |
chugu |
03/03/2017 |
sql |
integration-services |
language-reference |
[!INCLUDEsqlserver-ssis]
[!INCLUDE SQL Server]
Sets the description of a folder in the [!INCLUDEssISnoversion] catalog.
catalog.set_folder_description [ @folder_name = ] folder_name
, [ @folder_description = ] folder_description
[ @folder_name = ] folder_name
The name of the folder. The folder_name is nvarchar(128).
[ @folder_description = ] folder_description
The description of the folder. The folder_description is nvarchar(MAX).
None
None
This stored procedure requires one of the following permissions:
-
Membership to the ssis_admin database role
-
Membership to the sysadmin server role
The stored procedure returns a message to confirm the setting of new folder description.