From quine's wiki

Main: SQLServer2008StopWords

CREATE FULLTEXT STOPLIST (Transact-SQL)

Configure and Manage Stopwords and Stoplists for Full-Text Search: Changing the Stopwords in a Stoplist

ALTER FULLTEXT INDEX (Transact-SQL)

How to: View or Change the Properties of a Full-Text Index (SQL Server Management Studio)

Google Book Search for "sql server 2008 remove stop words from a query"

EXECUTE sp_configure 'show advanced options', 1;
RECONFIGURE WITH OVERRIDE;
GO

EXECUTE sp_configure 'transform noise words', 1;
RECONFIGURE WITH OVERRIDE;
GO

sp_configure (Transact-SQL)