Post reply

Question about an View point to another table in diferent database

  • February 8, 2008 at 2:42 am

    #378427

    Hi guys,

    Let me explain my situation, i have two databases one used for replication (DB-A), and another for diferent purpouse (DB-B).

    I have many views in DB-B pointing to DB-A, trought the script select * from DB-B.dbo., my problem is that when i add an column in the table from DB-A, the view doesnt show the new column.

    This is resolved by runing Alter View script of the view.

    Any suggestion, to resolve this???

  • February 8, 2008 at 8:36 am

    #776464

    i have found out the problem and how to resolve it 😛

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

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