view or function <insert name> is not updatable (TOP clause)
marcl508
Posts: 24
When I use the Packager tool everything works fine, but when I use the Toolkit samples I get the following when I try to run the package:
The only change I made to the sample package generator was to fix the error with BLOBs and primary keys. Other than that it is the same.
The view or function 'dbo.rep_OpenDocumentInventory' is not updatable because the definition contains the TOP clause. System.Data.SqlClient.SqlException
The only change I made to the sample package generator was to fix the error with BLOBs and primary keys. Other than that it is the same.
This discussion has been closed.
Comments
Is dbo.Rep_OpenDocumentInentory an indexed view? If it is, you may want to try de-selecting data migration for this view, and only allow the schema (DDL) to be migrated. Indexed views should not contain TOP n in the SELECT statement.