Fabian,

No, you are doing it properly.

>I'm trying to have the primary key of a table as an Identity column, but when using a remote view that is buffered, I don't get the new Identity when adding a record unless I get the @@Identity from SQL2000 with another SQL statement, is there any way to refresh the view so the id is not 0 and instead picks up the identity from SQL?
>
>Thanks in advance for any help provided.
>
>Fabian