Nuta
Dostęp do tej strony wymaga autoryzacji. Możesz spróbować się zalogować lub zmienić katalog.
Dostęp do tej strony wymaga autoryzacji. Możesz spróbować zmienić katalogi.
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.
.gif "Ikona łącza do tematu")
Transact-SQL Syntax Conventions
Składnia
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. |
Uwagi
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.