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

MS Sql Server LazyDBA home page