Re: SQL2005 FT error adding table column

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

do an sp_help tablename and paste all the results here.

p_id varchar no 50 no no no SQL_Latin1_General_CP1_CI_AS
p_name varchar no 255 yes no no SQL_Latin1_General_CP1_CI_AS
p_url_name varchar no 255 yes no no SQL_Latin1_General_CP1_CI_AS
p_desc varchar no 1024 yes no no SQL_Latin1_General_CP1_CI_AS
p_img_lg varchar no 255 no no no SQL_Latin1_General_CP1_CI_AS
p_img_sm varchar no 255 no no no SQL_Latin1_General_CP1_CI_AS
p_img_lg_h int no 4 10 0 no (n/a) (n/a) NULL
p_img_lg_w int no 4 10 0 no (n/a) (n/a) NULL
p_img_sm_h int no 4 10 0 no (n/a) (n/a) NULL
p_img_sm_w int no 4 10 0 no (n/a) (n/a) NULL
p_status int no 4 10 0 no (n/a) (n/a) NULL
p_man int no 4 10 0 no (n/a) (n/a) NULL
p_dist int no 4 10 0 no (n/a) (n/a) NULL
p_featured int no 4 10 0 no (n/a) (n/a) NULL
p_hidden int no 4 10 0 no (n/a) (n/a) NULL
p_perishable bit no 1 no (n/a) (n/a) NULL
display_order int no 4 10 0 no (n/a) (n/a) NULL
row_id int no 4 10 0 no (n/a) (n/a) NULL
META_title varchar no 100 yes no no SQL_Latin1_General_CP1_CI_AS
META_desc varchar no 1024 yes no no SQL_Latin1_General_CP1_CI_AS
META_keyword varchar no 1024 yes no no
SQL_Latin1_General_CP1_CI_AS
date_created datetime no 8 no (n/a) (n/a) NULL
date_modified datetime no 8 no (n/a) (n/a) NULL


"msft-sql" <aklist@xxxxxxxxxxxxx> wrote in message
news:uiHYQyIYGHA.4920@xxxxxxxxxxxxxxxxxxxxxxx
Is this enough info:

p_id varchar(50) Unchecked
p_name varchar(255) Unchecked
p_subTitle varchar(255) Checked
p_desc varchar(1000) Checked
p_ingredients varchar(1000) Checked
p_img_lg varchar(255) Unchecked
p_img_sm varchar(255) Unchecked
p_img_pom varchar(255) Checked
p_img_lg_h int Unchecked
p_img_lg_w int Unchecked
p_img_sm_h int Unchecked
p_img_sm_w int Unchecked
p_img_pom_h smallint Checked
p_img_pom_w smallint Checked
p_status int Unchecked
p_man int Unchecked
p_dist int Unchecked
p_featured int Unchecked
p_cat varchar(25) Unchecked
p_hidden int Unchecked
display_order int Unchecked
row_id int Unchecked
META_title varchar(100) Checked
META_desc varchar(1024) Checked
META_keyword varchar(1024) Checked
p_perishable bit Unchecked
Unchecked

When I click on "Columns" in the FT Index Properties pane, the error is:

TITLE: Microsoft SQL Server Management Studio
------------------------------

Cannot load Columns Index Properties form.

------------------------------
ADDITIONAL INFORMATION:

Property TypeColumnName is not available for FullTextIndexColumn
'[p_desc]'. This property may not exist for this object, or may not be
retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo)

The database was originally created in SQL2000, and this is an upgraded
installation to 2005.


"Hilary Cotter" <hilary.cotter@xxxxxxxxx> wrote in message
news:upMmVICYGHA.3808@xxxxxxxxxxxxxxxxxxxxxxx
Could you post the schema for the problem table here?

--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.

This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



"msft-sql" <aklist@xxxxxxxxxxxxx> wrote in message
news:ehEIui$XGHA.5004@xxxxxxxxxxxxxxxxxxxxxxx
I'm new to SQL 2005, and I'm trying to create my first FT catalog using
the wizard.

After selecting the tables and columns I wanted in the index, I
received an errorbox, the copied text of which is:


TITLE: Microsoft SQL Server Management Studio
------------------------------

Cannot load tables or views.

------------------------------
ADDITIONAL INFORMATION:

Property TypeColumnName is not available for FullTextIndexColumn
'[m_name]'. This property may not exist for this object, or may not be
retrievable due to insufficient access rights.
(Microsoft.SqlServer.Smo)

For help, click:
http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=TypeColumnName&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

That link doesn't provide any more information. The catalog seems to be
created, but if I pull up its properties and click "tables", the error
pops up again.









.

Quantcast