title | description | author | ms.author | ms.date | ms.service | ms.subservice | ms.topic |
---|---|---|---|---|---|---|---|
catalog.delete_environment_reference (SSISDB Database) |
catalog.delete_environment_reference (SSISDB Database) |
chugugrace |
chugu |
03/06/2017 |
sql |
integration-services |
language-reference |
[!INCLUDEsqlserver-ssis]
[!INCLUDE SQL Server]
Deletes an environment reference from a project in the [!INCLUDEssISnoversion] catalog.
catalog.delete_environment_reference [ @reference_id = ] reference_id
[ @reference_id = ] reference_id
The unique identifier of the environment reference. The reference_id is bigint.
0 (success)
None
This stored procedure requires one of the following permissions:
-
MODIFY permission on the project
-
Membership to the ssis_admin database role
-
Membership to the sysadmin server role
The following list describes some conditions that may raise an error or warning:
-
The environment reference identifier is not valid
-
The user does not have the appropriate permissions