Fair enough, but if he's using SQL Standard, and SQL Standard doesn't
support Indexed Views (whereas SQL Enterprise, and Express apparrently,
does) then he's SOL....
I don't think he said he was using Express edition? If he did then I stand
corrected and apologise profusely. =)

Jeremy Greaves
Fenris Software Consulting, Inc

>From: "BOUCHE Sylvain GBM "
><mssqldba-ezmlmshield-x67499712.[Email address protected]
>To: "LazyDBA Discussion" <[Email address protected]
>Subject: RE: Indexes on Views
>Date: Mon, 30 Apr 2007 17:53:00 +0100
>
> Works fine with express edition
>
>-----Original Message-----
>From: Jeremy Greaves
>[mailto:mssqldba-ezmlmshield-x12879270.[Email address protected]
>Sent: 30 April 2007 17:32
>To: LazyDBA Discussion
>Subject: RE: Indexes on Views
>
>
>Plus it needs to be SQL Enterprise Edition I believe...
>
>Jeremy Greaves
>Fenris Software Consulting, Inc
>
>
> >From: "BOUCHE Sylvain GBM "
> ><mssqldba-ezmlmshield-x20219198.[Email address protected]
> >To: "LazyDBA Discussion" <[Email address protected]
> >Subject: RE: Indexes on Views
> >Date: Mon, 30 Apr 2007 15:09:29 +0100
> >
> >You'll need these:
> >Shema binding +No outer join +No agrregate +No double referencing of
> >the same object
> >
> >-----Original Message-----
> >From: Gaurav Kohli
> >[mailto:mssqldba-ezmlmshield-x80103358.[Email address protected]
> >Sent: 30 April 2007 09:49
> >To: LazyDBA Discussion
> >Subject: Indexes on Views
> >
> >Hi Gurus,
> >
> >
> >
> >I'm trying to create indexes on one of the "Views" that we have in our
> >database. The database is on SQL Server 2000.
> >
> >
> >
> >When I open the "View" in "enterprise manager" and Right-click the
> >background of the Diagram pane, the "Manage Indexes" option appears
> >disabled.
> >
> >
> >
> >Any idea about this?
> >
> >
> >
> >Thanks
> >
> >Gaurav Kohli
> >
> >
> >
> >---------------------------------------------------------------------
> >TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
> >a dba
> >job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com To
> >unsubscribe: http://www.lazydba.com/unsubscribe.html
> >
> >***********************************************************************
> >************ The Royal Bank of Scotland plc. Registered in Scotland No
> >90312. Registered
> >Office: 36 St Andrew Square, Edinburgh EH2 2YB.
> >Authorised and regulated by the Financial Services Authority
> >
> >This e-mail message is confidential and for use by the addressee only.
> >If the message is received by anyone other than the addressee, please
> >return the message to the sender by replying to it and then delete the
> >message from your computer. Internet e-mails are not necessarily
> >secure. The Royal Bank of Scotland plc does not accept responsibility
> >for changes made to this message after it was sent.
> >
> >Whilst all reasonable care has been taken to avoid the transmission of
> >viruses, it is the responsibility of the recipient to ensure that the
> >onward transmission, opening or use of this message and any attachments
> >will not adversely affect its systems or data. No responsibility is
> >accepted by The Royal Bank of Scotland plc in this regard and the
> >recipient should carry out such virus and other checks as it considers
> >appropriate.
> >Visit our websites at:
> >www.rbs.com
> >www.rbsgc.com
> >www.rbsmarkets.com
> >***********************************************************************
> >************
> >
> >
> >---------------------------------------------------------------------
> >TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post
> >a dba job: http://jobs.lazydba.com To subscribe :
> >http://www.LazyDBA.com To unsubscribe:
> >http://www.lazydba.com/unsubscribe.html
> >
>
>
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
>dba
>job: http://jobs.lazydba.com To subscribe : http://www.LazyDBA.com To
>unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>



MS Sql Server LazyDBA home page