BUG: Can't Insert into Views That Have INSTEAD OF Trigger in Enterprise Manager (288969)

SYMPTOMS

SQL Server Books Online states that it is possible to insert values for timestamp, identity, and computed columns in views that have INSTEAD OF triggers defined on them.

If you attempt to do this in Enterprise Manager, you receive the following error message:

Cannot edit this cell

MORE INFORMATION

Steps to Reproduce Behavior

Create a table with an identity column as follows:

CREATE TABLE myTab(
c1 int,
c2 int identity(1,1))

Create a view that reads from the table:

CREATE VIEW myView as 
       SELECT * FROM myTab

Create an INSTEAD OF insert trigger on the view:

CREATE TRIGGER myTrig ON myView INSTEAD OF INSERT AS
       INSERT INTO myTab(c1) SELECT c1 FROM inserted

In Enterprise Manager, right-click the view, point to Open View, and select Return all rows.
In the new window, if you attempt to insert into the identity column, the error message is displayed.