Anteckning
Åtkomst till den här sidan kräver auktorisering. Du kan prova att logga in eller ändra kataloger.
Åtkomst till den här sidan kräver auktorisering. Du kan prova att ändra kataloger.
Applies to: 
SQL Server
Details
| Attribute | Value |
|---|---|
| Product Name | SQL Server |
| 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. |
Explanation
This message occurs when you try to drop a clustered index on a table that contains FILESTREAM data, and you specify a MOVE TO clause for the base data, but you do not specify a FILESTREAM_ON clause for the FILESTREAM data.
User Action
When dropping a clustered index on a table that contains FILESTREAM data, use one of the following options:
Specify both a MOVE TO clause for the base data and a FILESTREAM_ON clause for the FILESTREAM data.
Do not specify either a MOVE TO clause for the base data or a FILESTREAM_ON 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.
DROP INDEX [<clustered_index_name>] ON [<table_name>]
WITH ( ONLINE = OFF, MOVE TO [PRIMARY] )
GO
The following example succeeds because both a MOVE TO clause for the base data and a FILESTREAM_ON clause for the FILESTREAM data are specified.
DROP INDEX [<clustered_index_name>] ON [<table_name>]
WITH ( ONLINE = OFF, MOVE TO [PRIMARY], filestream_on 'default' )
GO
The following example also succeeds because neither a MOVE TO clause for the base data nor a FILESTREAM_ON clause for the FILESTREAM data is specified.
DROP INDEX [<clustered_index_name>] ON [<table_name>]
WITH ( ONLINE = OFF )
GO