Error when clicking Full-Text Index Properties in SQL Server Management Studio

Question

TITLE: Microsoft SQL Server Management Studio

Cannot load Full-Text General Catalog Properties form.

ADDITIONAL INFORMATION:

Object of type 'SearchPropertyList' is not supported on Microsoft Azure SQL Database. (Microsoft.SqlServer.Smo)

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.46041.41+(SMO-master-A)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.NotSupportedOnCloudWithDetails&LinkId=20476

BUTTONS:

OK

Answer

Hi @Al , welcome to Microsoft Q&A forum.

I am able to repro the issue with multiple versions of SSMS. As per the error message 'SearchPropertyList' is not supported in Azure SQL Database but if we try to create it using TSQL it works.(CREATE SEARCH PROPERTY LIST)

CREATE SEARCH PROPERTY LIST DocumentPropertyList;    
GO    
USE yourdatabase;    
ALTER FULLTEXT INDEX ON schemaname.tableName     
   SET SEARCH PROPERTY LIST DocumentPropertyList    
   WITH NO POPULATION;     
GO

This looks an integration issue between SSMS and Azure SQL Database Full-Text Index. If you check the storage as mentioned in the below screenshot, it is missing the 'Search Property Lists' option, which I think is causing issue while rendering the properties GUI through SSMS.

Now as a workaround, we can use TSQL to check the properties as mentioned in below article:

View the properties of a full-text index

Please let us know if this helps or we can discuss further.

----------

if answer helps, please mark it 'Accept Answer'

Error when clicking Full-Text Index > Properties in SQL Server Management Studio

1 answer