Post reply

Change column is_published in sys.databases?

  • June 19, 2008 at 3:56 am

    #187311

    Hi,

    I need to detach a database that has is_published = 1 on sys.databases, but it is not replicated and never was.

    As I'm not able do change that column directly, is there a stored procedure that changes this column?

    Best Regards,

    Jan

  • June 19, 2008 at 8:15 am

    #831128

    You might want to check out the posts here - http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=3416564&SiteID=17 - as they may help with one suggestion in there. Additionally, you should try running sp_helpdistributor to see if this database still recognizes that it has a distributor associated with it.

    No concrete answer but it might give you a start in seeing what is going on.

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply