sp_removedbreplication (T-SQL)

Removes all replication objects from a database without updating data at the Distributor.

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  

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.