Alternative for sp_dboption published false

• spidey73

  SSChasing Mays

  Points: 658

  More actions

  November 25, 2015 at 6:31 am

  #399382

  With SQL 2012 MS removed the sp_dboption.

  For most actions I can find an ALTER DATABASE SET option.

  But for the SP_DBOPTION <dbname> 'published', 'false' I can not fins a alternative.

  In a stored procedure I use the publication is removed and after that I want to set the database as not published. (which I did in SQL 2008R2 with the sp_dboption)

  Is there a way to do this in SQL 2012+ other then update the is_published column in sys.databases?

• prvmine

  SSCertifiable

  Points: 7006

  More actions

  November 25, 2015 at 9:10 am

  #1842338

  try

  sp_replicationdboption

• spidey73

  SSChasing Mays

  Points: 658

  More actions

  November 26, 2015 at 2:43 am

  #1842470

  oke, it can be that simple!

  Thanks.

  For further reference, I know use

  exec sp_replicationdboption @dbname = <database name>, @optname = 'publish', @value = 'false';