Not able to rename dbo.MSreplication_queue table

  • Dear All,

    In publisher i observed dbo.MSreplication_queue table.This table was exist due to previous setup of replication.But we recreated replication with new senario.So we want delete this qued table.

    Before we would plan to change the table name to monitor for week.

    So we are trying to cahnge the name of the table.But we are getting below error

    Msg 15001, Level 16, State 1, Procedure sp_rename, Line 362

    Object 'dbo.MSreplication_queue' does not exist or is not a valid object for this operation.

    Querry we are using

    sp_rename 'oldname','newname'

    go

    Please help me to solve this issue

  • Are you in the correct database when you run sp_rename?

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

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

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