MS SQL Server Management Studio R2
Posted on 2013-06-11
See/read questions marked with >>>> below;
I have googled for a solution on this, yet have not found a solution. I have installed; MS SQL Sever Management Studio: SQL Server 2008 R2. With it, it uses the AdventureWorksDW2008R2 samples from ;
C:\Program Files\Microsoft SQL Server\100\Samples\AdventureWorksDW2008R2
The instructions mention to set the PATH Environment variable;
Before you compile Microsoft .NET Framework common language runtime (CLR) samples for SQL Server, verify that the path of the version of the .NET Framework compiler is the first Framework directory in the PATH environment variable. The location of the compiler that is shipped with this release of SQL Server is C:\<Windows root directory>\Microsoft.NET\Framework\v2.0.x. Drive C is the installation drive, <Windows root directory> is either Windows or WINNT, and x is five digits.
This is where I am at now. I learned that I have do download; AdventureWorks 2008R2 OLTP,
which I did and ran/executed; instawdb
The Studio then showed the content of the file, see attachment. From this script I have these questions now;
>>> When I was installing the studio, I believe I saw the selection for this, but can't remember if I selected it. Is there a way of checking whether this is enabled without going over the installation again?
-- Be sure to enable FULL TEXT SEARCH before running this script
I now know that I have to do this;
Create a full-text catalog.
>>> How does one create a "full text catalog?"
On each table that you want to search, create a full-text index by:
Identify each text columns that you want to include in the full-text index.
-->> WARNING: THIS SCRIPT MUST BE RUN IN SQLCMD MODE INSIDE SQL SERVER MANAGEMENT STUDIO. <<--
:on error exit
* In order to run this script manually, either set the environment variables,
* or uncomment the setvar statements and provide the necessary values if
* the defaults are not correct for your installation.