Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 631
  • Last Modified:

SQL Full Text Search & Compatibility Mode

Hello, we have a SQL 2008 R2 Database running in compatibility mode 80.  If we were to start using Full Text Search, would this still work against the database being in mode 80?

Thanks.
0
Roxanne25
Asked:
Roxanne25
2 Solutions
 
lcohanDatabase AnalystCommented:
Yes, that should not be a problem as Full-text is an old feature of SQL.
0
 
Ross TurnerCommented:
i just built a database in compatibility mode 80 and create a Full Text Search on a table and it seemed to work fine.

So i think you are good to go......
0
 
Roxanne25Author Commented:
Thank you guys... much appreciated!
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now