question

Al-8191 avatar image
0 Votes"
Al-8191 asked ·

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

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


azure-sql-database
· 1
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Al-8191, just wanted to follow up on this thread.

0 Votes 0 ·

1 Answer

AnuragSharma-MSFT avatar image
0 Votes"
AnuragSharma-MSFT answered ·

Hi @Al-8191, 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.

75660-image.png

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'





image.png (16.8 KiB)
· 2 ·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi! Thanks for replying.

The reason why I need to access the Properties is because I want to set up a scheduled incremental index population.

Is there any way to achieve it using TSQL?

0 Votes 0 ·

Yes you can use TSQL to look for the properties as mentioned in the article:

View the properties of a full-text index

Please let us know if this helps.

0 Votes 0 ·