The sqlserver property defaultfulltextlanguagelcid is not available

Time:2020-10-31

Failed to view database properties after database snapshot

ADDITIONAL INFORMATION:

The requested dialog could not be displayed. (SqlMgmt)

——————————

Attribute defaultfulltextlanguagelcid is not available for database “[sk_ Master]”。 The object may not have this property, or it may not have sufficient access rights to retrieve it. ( Microsoft.SqlServer.Smo )

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=15.0.18131.0+((SSMS_Rel).190606-1032)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=DefaultFullTextLanguageLcid&LinkId=20476

——————————

Solution:

 

use sk_Master;
GO  
EXEC sp_configure 'show advanced options', 1 ;  
GO  
RECONFIGURE  
GO  
EXEC sp_configure 'default full-text language', 1043 ;  
GO  
RECONFIGURE  
GO 

 

Reference link:https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-default-full-text-language-server-configuration-option?view=sql-server-ver15