Re: insufficient key column information for updating or refreshing

Not possible. None of my views in this case are updateable.

Keith

"Helmut Woess" <user22@xxxxxxxx> wrote in message
news:1qbv6ogxbbhjs.1eu057cuz26zy$.dlg@xxxxxxxxxxxxx

I am not sure if this helps, but try to build your view with option WITH
VIEW_METADATA, for example:

CREATE VIEW dbo.vwAllCustomers WITH VIEW_METADATA
AS SELECT * FROM dbo.Customers

And then if you use INSTEAD-OF-Triggers together with your view you can
even directly insert/update/delete data.

bye,
Helmut


.