sp_dropdistributiondb (T-SQL)

Drops a distribution database. Drops the physical files used by the database if they are not used by another database.

Syntax

sp_dropdistributiondb [@database =] 'database'

Arguments

[@database =] 'database'

Is the database to drop. database is sysname, with no default.

Return Code Values

0 (success) or 1 (failure)

Remarks

sp_dropdistributiondb is used in all types of replication.

Permissions

Only members of the sysadmin fixed server role can execute sp_dropdistributiondb.

See Also