"nomad" <d.bedg***@ntlworld.com> wrote in message
news:1174043680.385207.143160@b75g2000hsg.googlegroups.com...
> Hi,
>
> I am currently running SQL 2005 SP2.  When I right click on a view I
> have the option to Edit it, so I can then view any comments entered
> for the view.  My colleague is also running SQL 2005 with SP2 but when
> he right clicks on a view it only gives him the option to modify,
> which isn;t the same as Edit.  We both have the same permissions so am
> unsure why this is happening.
>
> If anyone has any ideas why this may be happening, it would be greatly
> appreciated.
>
> Thanks
>

On Mar 18, 11:24 am, "Uri Dimant" <u***@iscar.co.il> wrote:
> Nomad
> Is the second user also member od sysadminserver role?
>
> "nomad" <d.bedg***@ntlworld.com> wrote in message
>
> news:1174043680.385207.143160@b75g2000hsg.googlegroups.com...
>
> > Hi,
>
> > I am currently running SQL 2005 SP2.  When I right click on a view I
> > have the option to Edit it, so I can then view any comments entered
> > for the view.  My colleague is also running SQL 2005 with SP2 but when
> > he right clicks on a view it only gives him the option to modify,
> > which isn;t the same as Edit.  We both have the same permissions so am
> > unsure why this is happening.
>
> > If anyone has any ideas why this may be happening, it would be greatly
> > appreciated.
>
> > Thanks