title: Sql query for full-text on a column
body: <p>I know, it's best to get to the point when I ask a question here, but if I don't explain the full situation, somebody more than likely would question why I'm in this predicament (that I actually explain starting in the third paragraph beginning with bold text), and in that case I would've had to explain it anyway, so, I decided to get that out of the way from the get-go.</p>
  
  <p>I used to have a better laptop, but my brothers ferrets spilled water on it. So, for the last year I've been using an older laptop. It works and is reasonably fast enough. But, it came with Windows 7, I installed Windows 8, 8.1, and now 10 on it. During all this time that I've had this machine (and yes, before it too), I've been doing computer programming as a hobby, and have gotten pretty decent at it. But, I've installed Visual Studio 2010, 2012, 2013, and 2015 on it (and still have all those additions installed, because of a memory of once when I uninstalled an older Visual Studio upon installing a new Visual Studio - the un-installation of the old Visual Studio somehow did something to the new Visual Studio and made it unusable, which forced me to reinstall Windows and start back from square one, and reinstalling Windows on this machine would be a horrible decision for me because I also produce music as an on-again-off-again hobby, and it has a library of very important plugins for music production which I don't want to loose - among other reasons).</p>
  
  <p><strong>But the issue at the core of my question is this -</strong> I've installed several editions of SQL Server on this machine - 2008, 2008 R2, 2012, and 2014. Having done this, it created a strange scenario. In Visual Studio 2015, I can easily create and manipulate SQL databases. But, as probably everybody who knows anything about Microsoft SQL Server knows, there are some database manipulation features, even in Visual Studio 2015 (with it's more advanced manipulation capabilities than previous editions), that just cannot be done, and the only place to do such things is inside of SQL Server Management Studio. Well, since I've installed several versions of SQL Server during the lifetime of this machine across several editions of Windows, something pretty strange has happened. Every single time I installed SQL Server - I installed with Advanced Services (with full-text search enabled). <strong>Ok, so, when I go into SQL Server Management Studio 2014 -</strong> it just will not log into my database system and gives me an error message that says (among other things...) "<em>A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.</em>" <strong>Well the point is</strong>, I've made databases on different projects before, and I incorporated Full-Text services on a (or some...) columns in a Table before. Look, I understand T-SQL and can write it, but, I'm not exceptionally well-versed in it. So, when I've setup Full-Text services like I said on previous databases - it was (obviously) done inside of SQL Server Management Studio.</p>
  
  <p>So, <strong><em>the main point is -</em></strong> I have a Table that I'd like to set Full-Text services on a certain column in this database I made. Following this paragraph, I wrote an example create table script, and I highlight the column I'd like to have Full-Text services applied to, please can someone show me how to do this properly.</p>
  
  <pre><code>CREATE TABLE [dbo].[thisTable] (
      [Id]  INT             IDENTITY (1, 1) NOT NULL,
      [aColumn]    DATETIME        NOT NULL, 
      [INEEDFULLTEXTHERE] NVARCHAR (100)  NOT NULL &lt;&lt;&lt; the column I need full-text on
  )
  </code></pre>