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,
TomHello 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.
http://msdn2.microsoft.com/en-us/library/ms143761.aspx
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.|||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.

ful text index

I just created a full text index on a table and everything appears fine but
after populating it I still have an item count of zero. Any ideas?
tia,
jjTry executing Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
where pubs is replaced by the databse name in question. Assuming this
returned a 1, check through the eventlog to see if there are any errors. I
suspect there are.
Does this server have BUILTIN\Administrators account setup as sysadmin? If
not check out the KB 317746 article.
If this doesn't produce any results look at the following 2 KB articles:
277549 "PRB: Unable to Build Full-Text Catalog After You Modify"
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Co
mponent
Services]
http://support.microsoft.com/defaul...KB;EN-US;277549
317746 "PRB: SQL Server Full-Text Search Does Not Populate Catalogs"
http://support.microsoft.com/defaul...kb;en-us;317746
HTH
Francis
"jj" wrote:

> I just created a full text index on a table and everything appears fine b
ut
> after populating it I still have an item count of zero. Any ideas?
> tia,
> jj
>
>

ful text index

I just created a full text index on a table and everything appears fine but
after populating it I still have an item count of zero. Any ideas?
tia,
jjTry executing Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
where pubs is replaced by the databse name in question. Assuming this
returned a 1, check through the eventlog to see if there are any errors. I
suspect there are.
Does this server have BUILTIN\Administrators account setup as sysadmin? If
not check out the KB 317746 article.
If this doesn't produce any results look at the following 2 KB articles:
277549 "PRB: Unable to Build Full-Text Catalog After You Modify"
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
Services]
http://support.microsoft.com/default.aspx?scid=KB;EN-US;277549
317746 "PRB: SQL Server Full-Text Search Does Not Populate Catalogs"
http://support.microsoft.com/default.aspx?scid=kb;en-us;317746
HTH
Francis
"jj" wrote:
> I just created a full text index on a table and everything appears fine but
> after populating it I still have an item count of zero. Any ideas?
> tia,
> jj
>
>

ful text index

I just created a full text index on a table and everything appears fine but
after populating it I still have an item count of zero. Any ideas?
tia,
jj
Try executing Select DATABASEPROPERTY('Pubs', 'IsFulltextEnabled')
where pubs is replaced by the databse name in question. Assuming this
returned a 1, check through the eventlog to see if there are any errors. I
suspect there are.
Does this server have BUILTIN\Administrators account setup as sysadmin? If
not check out the KB 317746 article.
If this doesn't produce any results look at the following 2 KB articles:
277549 "PRB: Unable to Build Full-Text Catalog After You Modify"
MSSQLServer Logon Account Through [NT4.0) Control Panel [or Win2K Component
Services]
http://support.microsoft.com/default...B;EN-US;277549
317746 "PRB: SQL Server Full-Text Search Does Not Populate Catalogs"
http://support.microsoft.com/default...b;en-us;317746
HTH
Francis
"jj" wrote:

> I just created a full text index on a table and everything appears fine but
> after populating it I still have an item count of zero. Any ideas?
> tia,
> jj
>
>