sp_getsubscriptiondtspackagename (Transact-SQL)
Applies to: SQL Server
Returns the name of the Data Transformation Services (DTS) package used to transform data before they are sent to a Subscriber. This stored procedure is executed at the Publisher on any database.
Transact-SQL syntax conventions
Syntax
sp_getsubscriptiondtspackagename [ @publication = ] 'publication'
[ , [ @subscriber = ] 'subscriber' ]
Arguments
[ @publication = ] 'publication'
Is the name of the publication. 'publication' is sysname, with no default.
[ @subscriber = ] 'subscriber'
Is the name of the Subscriber. subscriber is sysname, with a default of NULL.
Return Code Values
0 (success) or 1 (failure)
Result Sets
Column name | Data type | Description |
---|---|---|
new_package_name | sysname | The name of the DTS package. |
Remarks
sp_getsubscriptiondtspackagename is used in snapshot replication and transactional replication.
Permissions
Only members of the sysadmin fixed server role or the db_owner fixed database role can execute sp_getsubscriptiondtspackagename.
Feedback
https://aka.ms/ContentUserFeedback.
În curând: Pe parcursul anului 2024, vom elimina treptat Probleme legate de GitHub ca mecanism de feedback pentru conținut și îl vom înlocui cu un nou sistem de feedback. Pentru mai multe informații, consultați:Trimiteți și vizualizați feedback pentru