Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    60

    Unanswered: Indexed view in Microsoft SQL 2000

    Just wonder how many of you are using or had used indexed view in SQL 2000? Please, share any details/info.

    We are currently using in and having problems as we are getting Errors 644, 'Couldn't find index...' every time we try to update the underlying tables.
    jaraba

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I have. Once.
    It is pretty rare that you would need this functionality. Explain your requirements in more detail and maybe we can either solve the problem or give you an alternate method.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Jul 2004
    Location
    Mars
    Posts
    137

    Thumbs up

    Check out this link, contains some info about Indexed Views. It may be of some use to you..

    http://msdn.microsoft.com/library/de...dexedViews.asp
    Sudar

    --
    My Blog

Posting Permissions

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