microsoft / sql-server-samples

Azure Data SQL Samples - Official Microsoft GitHub Repository containing code samples for SQL Server, Azure SQL, Azure Synapse, and Azure SQL Edge
Other
9.97k stars 8.85k forks source link

Importing AdventureWorks script does not work on fresh install of SSMS 19 #1263

Open nepp95 opened 7 months ago

nepp95 commented 7 months ago

When trying to create the database through the script provided here, the script fails on the Full Text dialog creation, since this is not by default added to a SSMS installation.

Msg 7609, Level 17, State 5, Line 3518
Full-Text Search is not installed, or a full-text component cannot be loaded.
Msg 7609, Level 17, State 5, Line 3525
Full-Text Search is not installed, or a full-text component cannot be loaded.
Msg 7609, Level 17, State 5, Line 3532
Full-Text Search is not installed, or a full-text component cannot be loaded.

There are also no clear instructions on how to install Full-Text Search anywhere on the Microsoft website.

nepp95 commented 6 months ago

Note: I have resolved this on my own system, but the issue still remains in the sense that there are no clear instructions which is what a sample is supposed to have.