Full-Text Search / User Instances

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

[96 byte] By [Marc_L] at [2008-2-7]

«« VSS 2005 can not show history.
»» variable not recongized

# 1

FTS is disabled for User Instances.

Mike

MikeWachal-MSFT at 2007-9-8 >

top of Msdn Tech,SQL Server,SQL Server Express...

# 2

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?

Marc_L at 2007-9-8 >

# 3

does this go for the default user instance as well

\sqlExpress

FergusLogic at 2007-9-8 >

# 4

.\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

MikeWachal-MSFT at 2007-9-8 >

# 5

Hi Marc,

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

Mike Wachal - SQL Express team

MikeWachal-MSFT at 2007-9-8 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech