catalog.delete_environment (SSISDB Database)
Applies to:
SQL Server
SSIS Integration Runtime in Azure Data Factory
Applies to:
SQL Server
Deletes an environment from a folder in the Integration Services catalog.
Syntax
catalog.delete_environment [ @folder_name = ] folder_name , [ @environment_name = ] environment_name
Arguments
[ @folder_name = ] folder_name
The name of the folder that contains the environment. The folder_name is nvarchar(128).
[ @environment_name = ] environment_name
The name of the environment that is to be deleted. The environment_name is nvarchar(128).
Return Code Value
0 (success)
Result Sets
None
Permissions
This stored procedure requires one of the following permissions:
READ and MODIFY permissions on the environment
Membership to the ssis_admin database role
Membership to the sysadmin server role
Errors and Warnings
The following list describes some conditions that may raise an error or warning:
The specified environment does not exist
The user does not have the appropriate permissions
Pripomienky
https://aka.ms/ContentUserFeedback.
Pripravujeme: V priebehu roka 2024 postupne zrušíme službu Problémy v službe GitHub ako mechanizmus pripomienok týkajúcich sa obsahu a nahradíme ju novým systémom pripomienok. Ďalšie informácie nájdete na stránke:Odoslať a zobraziť pripomienky pre