replication

• bala2

  SSCertifiable

  Points: 5547

  More actions

  June 15, 2010 at 10:40 pm

  #233752

  when i am tring to disable the distribution databse i am geting this error

  can not drop the distribution databse 'distribution' because it is currently in use.changed databse to context to master( ms sql server error 21122)

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  June 16, 2010 at 12:24 am

  #1180775

  This is the common error message you get when you try to drop any database that is in use.

  Are you trying this on test server? If yes, first remove the replication before dropping distribution database.