Results 1 to 2 of 2

Thread: Indexed view???

  1. #1
    Join Date
    Dec 2003
    Posts
    17

    Angry Unanswered: Indexed view???

    Hi,

    I have a problem trying to create an indexed view on SQL Server 2000. There are multiple databases, one of which stores system wide data. I would like to create an indexed view on the system wide data for each of the site databases.

    Is it possible to create an indexed view on data in another database?

    Cheers

  2. #2
    Join Date
    Oct 2001
    Location
    Naples, FL
    Posts
    273
    From BOL: All base tables referenced by the view (an indexes view) must be in the same database as the view and have the same owner as the view.
    ---------------
    Ray Higdon MCSE, MCDBA, CCNA

Posting Permissions

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