FTS Issue...

• David.Mizelle

  SSC-Addicted

  Points: 463

  More actions

  April 17, 2008 at 12:15 pm

  #120965

  I imported a table from an Oracle db to my sql server db and suddenly it's not available to be added to my FT catalog. The table already existed in SQL Server, but I had the import wizard drop & re-add the table. Now the table isn't available to be added to my FT catalog.

  Would anyone happen to know why this is happening?

  Thanks in advance,

  Dave

• David.Mizelle

  SSC-Addicted

  Points: 463

  More actions

  April 17, 2008 at 12:36 pm

  #803942

  I figured it out....must have PK on table and when dropped/recreated, the PK didn't get re-created.

  Thanks,

  Dave