Post reply

table is published for replication and cannot be changed

  • May 2, 2008 at 12:21 am

    #98937

    Dear all,

    I've just applied for a DBA job and the guys sent me a test.

    They must be good over there, I dont really know the answer for this one.

    Anyone would like to give us a hand to get this job?

    Thanks in advance.

    A published database has been restored onto a server with no replication. You now wish to make a change to one of the “published” tables. However when making a change you get an error message that the table is published for replication and cannot be changed. sp_dropsubscription and sp_droparticle will not drop the table from replication because there is no replication set up on this server. How would you get to a position to be able to change the table structure?

  • May 2, 2008 at 9:23 am

    #810161

    If we give you the answer, do we get the job?

    I'll give you a hint, but that's all. The database in question still thinks it's replicated.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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