How do you identify the the Distibution Database?

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  November 29, 2011 at 7:59 am

  #390983

  How do you identify the Distribution Database on a Server?

  EXEC sp_get_distributor

  [/code]

  installeddistribution serverdistribution db installedis distribution publisherhas remote distribution publisher

  1ATL-PROD-DB\ATL_PROD_DB_2005110

  I execute the following command:

  EXEC sp_repldone @xactid = NULL, @xact_seqno = NULL, @numtrans = 0, @time = 0, @reset = 1

  The I want to verify that it worked:

  USE [Distribution]

  GO

  EXEC sp_browsereplcmds

  But without knowing the Distribution Database I can't do so.

  The log_reuse_wait_desc is still REPLICATION.

  DECLARE @DatabaseName VARCHAR(50);

  SET @DatabaseName = 'CypressFL'

  SELECT name, recovery_model_desc, log_reuse_wait_desc

  FROM sys.databases

  WHERE name = @DatabaseName

  For better, quicker answers on T-SQL questions, click on the following...
  http://www.sqlservercentral.com/articles/Best+Practices/61537/

  For better answers on performance questions, click on the following...
  http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  November 30, 2011 at 12:20 am

  #1414458

  Try this:

  select * from sys.databases where is_distributor = 1

  sp_helpdistributiondb

  sp_helpdistributor