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
>



MS Sql Server LazyDBA home page