Post reply

Copy view failed

  • March 20, 2007 at 2:44 pm

    #153488

    Hello,

    I setup Transactional replication to copy views.

    The replication failed with error on:

          * Invalid object name 't_tableA_view'  MSSQL Server, error number: 208

    Anyone familiar with this error? Please advise.

    Thanks

    TJ

  • March 20, 2007 at 4:05 pm

    #696061

    Qualify view with schema/owner...

     

    MohammedU
    Microsoft SQL Server MVP

  • March 20, 2007 at 10:03 pm

    #696088

    Can U clarify more details?

    Thank U.

    Edwin

  • March 21, 2007 at 8:21 am

    #696165

    Should be:

    CREATE VIEW dbo.OverdueView

    AS

    SELECT

      Overdue.column1,

      Overdue.column2,

      Overdue.column

    From Overdue

    The view was created.  The replication copy over the file to UNC folder.  But it did not show up in Database.

    Thanks for helps.

    Edwin

Viewing 4 posts - 1 through 3 (of 3 total)

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