SQL Server 2000 partition view restrictions

Only SQL Server 2000 Development edition and Enterprise Edition allow insert, update, and delete operations in the partition view. To modify the partition view, the statement must meet the following conditions:

1. The insert statement must provide values for all columns in the view, even if the base member table has the default constraints for these columns or even if they allow null. For these member columns with the default definition, these statements cannot explicitly use the keyword default.

2. The value inserted into the partition column must satisfy at least one basic constraint. Otherwise, the insert operation will fail due to violation of the constraint.

3. Even if the column contains the default value defined in the corresponding member table, the default keyword cannot be specified in the update statement as the value in the set clause.

4. If the Member table contains text, ntext, or image columns, the primary key column cannot be modified using the update statement.

5. You cannot use the insert or update statement to modify the column of the identity column in the view as one or more member tables.

6. If one of the member tables contains the timestamp column, the view cannot be modified using the insert or update statement.

7. If the partition view or any member table in the insert, update, and delete statements for this view has an inner join, these statements are not allowed.

Note: To update the partition view, you must have the insert, update, and delete permissions on the member table.