View in 2005 says cell is read only

7 Aug 2006 4:18 AM

dc

Hi,

As a certified DBA in 2000 I've done hundreds of views in Enterprise
manager. I've just started to get my teeth into 2005.

As one of my first forays, I thought I'd whip up a typical view. No
problems, but when I execute, the results pane say 'cell is read only'.
I'm used to directly editing within the results pane in Enterprise Manager
(yeah, I know...I'm careful) but in SSMS the view doesn't allow me to edit
data. This is essential for the kind of stuff I do. What gives? This
particular view is just three tables joined, plain old select statement with
a column or two from each table. No criteria.

cheers

7 Aug 2006 7:56 AM

John Bell

Hi

It is possible to update data in views, for instance the vSalesPerson view
in the adventureworks database. Check the compatibility level of your
database and that you satisfy all the criteria to update the view
http://msdn2.microsoft.com/en-us/library/ms180800.aspx

John

Show quote

"dc" wrote:

> Hi,
>
> As a certified DBA in 2000 I've done hundreds of views in Enterprise
> manager. I've just started to get my teeth into 2005.
>
> As one of my first forays, I thought I'd whip up a typical view. No
> problems, but when I execute, the results pane say 'cell is read only'.
> I'm used to directly editing within the results pane in Enterprise Manager
> (yeah, I know...I'm careful) but in SSMS the view doesn't allow me to edit
> data. This is essential for the kind of stuff I do. What gives? This
> particular view is just three tables joined, plain old select statement with
> a column or two from each table. No criteria.
>
> cheers
>
>
>