Export (0) Print
Expand All
Expand Minimize

Indexed View Article Properties, Snapshot Tab

SQL Server 2000

The following options are available on the Snapshot tab of the Indexed View Article Properties dialog box.

Options

Keep the existing view

If an object with the same name as the destination object already exists at the Subscriber, keep the existing object at the Subscriber and do not publish this indexed view.

Drop the existing view

If object already exists at the Subscriber, drop the indexed view at the Subscriber and publish this indexed view.

Nonclustered indexes

Publishes all nonclustered indexes that exist with this indexed view article. This option is required if the destination object is an indexed view.

Extended properties

Publishes all extended properties that exist with this indexed view article.

User Triggers

Publishes all user triggers that exist with this indexed view article.

See Also

Publishing Data and Database Objects

Show:
© 2014 Microsoft