1793

Product Name

Event ID

1793

Event Source

MSSQLSERVER

Component

SQLEngine

Symbolic Name

FILESTREAM_BASEDATA_NEED_SAME_PARTITION

Message Text

Cannot drop index ’%.*ls’ since a partition scheme is not specified for FILESTREAM data.

This message occurs when you try to drop a clustered index on a table that contains

FILESTREAM data, and you specify a

clause for the base data, but you do not specify

a

clause for the FILESTREAM data.

When dropping a clustered index on a table that contains FILESTREAM data, use one of the

following options:

Specify both a

clause for the base data and a

clause for the

FILESTREAM data.

Do not specify either a

clause for the base data or a

clause

for the FILESTREAM data.

The following example fails because a partition scheme is specified for the base data, but is not

specified for the FILESTREAM data.

Transact-SQL

ﾉ

Expand table