TechTalkz.com Logo

Go Back   TechTalkz.com Technology & Computer Troubleshooting Forums > Tech Support Archives > Microsoft > Microsoft SQL Server

Notices

Full Text in SQL 2005 vs SQL Express

Microsoft SQL Server


Reply
 
Thread Tools Display Modes
Old 08-12-2007, 10:50 AM   #1
TomT
Guest
 
Posts: n/a
Full Text in SQL 2005 vs SQL Express

Does full text work the same in both of these? From what I've read, it
appears SQl Express only searches in text columns....

I have a client who needs to search in a a column which contains imported
Word docs, etc. (varbinary(max)). Can this be done in the Express version or
not?

Thanks,

Tom
  Reply With Quote
Old 08-12-2007, 10:53 AM   #2
Wei Lu [MSFT]
Guest
 
Posts: n/a
RE: Full Text in SQL 2005 vs SQL Express

Hello Tom,

According to this MSDN article, SQL Express did not support to full-text
query the varbinary(max) column. But the SQL Express with Advanced Services
support.



You may try to use that Edition.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

  Reply With Quote
Old 11-12-2007, 03:51 PM   #3
Wei Lu [MSFT]
Guest
 
Posts: n/a
RE: Full Text in SQL 2005 vs SQL Express

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

  Reply With Quote
Old 11-12-2007, 03:51 PM   #4
Wei Lu [MSFT]
Guest
 
Posts: n/a
RE: Full Text in SQL 2005 vs SQL Express

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

  Reply With Quote
Old 11-12-2007, 04:01 PM   #5
Wei Lu [MSFT]
Guest
 
Posts: n/a
RE: Full Text in SQL 2005 vs SQL Express

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

  Reply With Quote
Old 11-12-2007, 04:02 PM   #6
Wei Lu [MSFT]
Guest
 
Posts: n/a
RE: Full Text in SQL 2005 vs SQL Express

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

  Reply With Quote
Old 11-12-2007, 04:29 PM   #7
Wei Lu [MSFT]
Guest
 
Posts: n/a
RE: Full Text in SQL 2005 vs SQL Express

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

  Reply With Quote
Old 11-12-2007, 04:43 PM   #8
Wei Lu [MSFT]
Guest
 
Posts: n/a
RE: Full Text in SQL 2005 vs SQL Express

Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

  Reply With Quote
Reply

Thread Tools
Display Modes



< Windows Help - MS Office Help - Hardware Support >


New To Site? Need Help?

All times are GMT +5.5. The time now is 07:37 PM.


vBulletin, Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO
Copyright © 2005-2009, TechTalkz.com. All Rights Reserved - Privacy Policy
Valid XHTML 1.0 Transitional