Sunday, February 19, 2012

Full-Text Search / User Instances

Is there any documentation on using full-text search with user instances? Is it even supported?

FTS is disabled for User Instances.

Mike

|||

We just spent quite a bit of time adding support for user instances into our application. It solves a number of problems for us and we're very happy with how it works. But I wouldn't have done it had I known about the FTS limitation.

Please tell me there is a chance of this changing at some point?

|||

does this go for the default user instance as well

\sqlExpress

|||

.\sqlexpress is not a User Instance, it is the default named instance that SQL Express installs to; we call this the "main" instance. FTS is functional in the main instance.

Mike Wachal - SQL Express team

|||

Hi Marc,

This won't change for SQL 2005 but we are investigating it for a future version.

Mike Wachal - SQL Express team

No comments:

Post a Comment