Post reply

Replication issue

  • August 7, 2009 at 8:36 am

    #140584

    Database 'DB_NAME' contains no objects that can be replicated with the selected publication type. Click Back to choose another database or change the publication type

  • August 7, 2009 at 9:01 am

    #1036060

    Is there a question here?

    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

  • August 7, 2009 at 9:05 am

    #1036062

    yes, i can not create a Publication, when I try to create publication I am getting this error

  • August 7, 2009 at 9:20 am

    #1036072

    Does the database contain any objects that can be replicated?

    What type of replication have you selected?

    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

  • August 7, 2009 at 9:25 am

    #1036077

    I have a 15 table to replicate, I am using Transactional replication, but I try other repliactiion too.

    How should I know all these tables is ready for replication. even I try to check mark all table but it is not checking them, I am getting read cross circle in frount of each table

  • August 7, 2009 at 9:37 am

    #1036086

    Do the tables have primary keys? It's required for transactional replication.

    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

  • August 7, 2009 at 10:09 am

    #1036120

    Thanks, I got it, but I am using sysadim login but getting a login error

    cannot create the agent job '@job_login' must bea valid Windows login in the from:

    'MACHINE\login' or DOMAIN\Login

  • August 7, 2009 at 11:37 am

    #1036195

    Is your service running under domain user account or local system?

    -Roy

  • August 7, 2009 at 12:31 pm

    #1036229

    Loal domin

  • August 7, 2009 at 12:40 pm

    #1036237

    Local domain?

    Do you mean Local System? If so run the SQL Service and SQL Agent under domain account.

    -Roy

  • August 8, 2009 at 10:37 am

    #1036411

    Thanks

  • July 21, 2010 at 7:35 pm

    #1196592

    Super, thanks for tip about PK, Gila. That was my trouble today.

  • February 18, 2011 at 1:53 am

    #1288680

    Hi,

    Creating publisher for transactional replication firstly insure that the table have primary key or not.

    If the table have primary key you can add the table in the publication else you can't.

Viewing 13 posts - 1 through 12 (of 12 total)

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