Skip to content

SQL-Articles

On Premise and Cloud Database Knowledge Base

Tag: fulltext

SQL Server 2005 Full Text Search

We had a requirement where the user had to do a search on Overview/description field which had nvarchar (max) data type. Full text search can be used for searching against the LOB data types like nvarchar (max), text and BLOB data types like varbinary (max) and image data type. Please note that in image and… Continue reading SQL Server 2005 Full Text Search

Published March 4, 2009
Categorized as DBA Tagged FTS, fulltext, sql 2005

Recent Posts

  • CSSUG February 2020 Meet
  • CSSUG January 2020 Meet
  • CSSUG November 2019 Meet
  • CSSUG October 2019 Meet
  • Dropping a Subscriber from AG Publisher
SQL-Articles
Proudly powered by WordPress.