Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2003

    Unanswered: Should Visual Foxpro remote view using dbo?

    When I look at the sql statement of remote views, I notice sometimes the table is qualified with dbo. Should I remove dbo. from the remote views and why?

    Thank you.

  2. #2
    Join Date
    Aug 2004
    1.) Does it work with the .dbo. ? If so why would you change it.

    2.) If it does not work... then I would say you need to look at the database/table ownership in SQL. In SQL DBO = DataBase Owner. If you mess with it there is a REAL good chance that your Remote view will be broken because your SQL statement will not be able to find the table.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts