view or function <insert name> is not updatable (TOP clause)

marcl508marcl508 Posts: 24
edited December 30, 2004 1:36PM in SQL Toolkit Previous Versions
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 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.

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello,

    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.
This discussion has been closed.