sp_removedbreplication
Removes all replication objects from a database without updating data at the Distributor. This stored procedure is executed at the Publisher on the publication database or at the Subscriber, on the subscription database.
Syntax
sp_removedbreplication [ @dbname = ] 'dbname'
Arguments
[@dbname =] 'dbname'
Is the name of the database. dbname is sysname, with no default.
Return Code Values
0 (success) or 1 (failure)
Remarks
sp_removedbreplication is used in all types of replication.
sp_removedbreplication is useful when restoring a replicated database that has no replication objects needing to be restored.
Permissions
Only members of the sysadmin fixed server role can execute sp_removedbreplication.
See Also
'
Comments (
)
)
Link to this page:
//www.vb-net.com/Sql/Sql/Ts_sp_repl3_1mlq.htm
|
|