Export (0) Print
Expand All
Expand Minimize

sp_removedbreplication

SQL Server 2000

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

System Stored Procedures

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft