DTS and Full-Text Catalogs

• valdyv

  Grasshopper

  Points: 23

  More actions

  April 28, 2002 at 7:33 pm

  #105318

  Hi there

  Basically ... I want to do DTS Exporting data through a wizard from one SQLServer 2000 to another. The copy method that I use is the 'Copy objects and data between SQL Server databases'.

  But I realise that everytime I do DTS over ... I need to define again a full-text indexing on one of the table in the targeted sql server.

  So ... the question is there any way that with a DTS that you can export Full-Text catalogs object to another sql server database?

  Thanks, Val

  PS.

  * Currently I have to do the a SQl Job on the targeted server that run this following query:

  exec sp_fulltext_table 'Content', 'Create', 'Cat_MAWeb', 'PK_Content'

  exec sp_fulltext_column 'Content', 'Content_Text', 'Add'

  .. to solve this issue.

• Andy Warren

  SSC Guru

  Points: 119912

  More actions

  April 28, 2002 at 7:40 pm

  #428001

  Are you dropping the table each time?

  Andy

  Andy
  Connect with me on LinkedIn