Post reply

Snapshot Replication

  • May 28, 2012 at 11:39 am

    #269545

    I am getting error "Hint noexpand on object xxx is invalid" when running Distributor to Subscriber agent. Is there a workaround or fix?

    Thanks much.

  • June 2, 2012 at 7:35 pm

    #1496237

    Is object xxx an indexed view on both the publisher and the subscriber? The NOEXPAND hint applies to only indexed view and if you're not replicating indexes, then the view may not be indexed on the subscriber.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

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

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