Full Text Image Type

Hi,
Can anybody tell me from which system tables / catalog views can I get the
Full Text Image Type for a Column in SQL 2005 (Yukon).
TIA
PrasadWith
SELECT *
FROM INFORMATION_sCHEMA.COLUMNS
WHERE CHARACTER_OCTET_LENGTH > 8000 OR
CHARACTER_OCTET_LENGTH = -1
you will get all image, varbinary(max), text, varchar(max), ntext,
nvarchar(max) and xml data type columns.
--
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"Prasad" <ekke_nikhil@.yahoo.co.uk> wrote in message
news:O3EPbsw$FHA.4012@.TK2MSFTNGP10.phx.gbl...
> Hi,
> Can anybody tell me from which system tables / catalog views can I get the
> Full Text Image Type for a Column in SQL 2005 (Yukon).
>
> TIA
> Prasad
>
>

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