Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Materialized view in sql server 2000

Author  Topic 

arorarahul.0688
Posting Yak Master

125 Posts

Posted - 2008-03-12 : 02:05:40
Can some one please help to find out that how can i implement the materialized view in sql server 2000? thanx for consideration.

Rahul Arora
07 Batch
NCCE Israna,


######################
IMPOSSIBLE = I+M+POSSIBLE

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-03-12 : 02:22:41
I think it's called indexed views. Look in Books Online. There is also a checklist for about 21 things that must be set to make indexed views work.



E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

arorarahul.0688
Posting Yak Master

125 Posts

Posted - 2008-03-12 : 10:05:55
quote:
Originally posted by Peso

I think it's called indexed views. Look in Books Online. There is also a checklist for about 21 things that must be set to make indexed views work.



E 12°55'05.25"
N 56°04'39.16"



thanx peso i searched that topic on net and get few good articles

like this one

http://www.akadia.com/services/sqlsrv_matviews.html

Rahul Arora
07 Batch
NCCE Israna,


######################
IMPOSSIBLE = I+M+POSSIBLE
Go to Top of Page
   

- Advertisement -