Basically the DTS is doing a drop table and then creating a new table, so the full text catalog is broken.
If you run an alter table statement to do the change then you won't have to redo the catalog. You might also be able to stop the full text engine run the DTS then restart it. > -----Original Message----- > From: Jacob [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 26, 2006 1:03 PM > To: CF-Community > Subject: RE: SQL 2000 Full Text search question. > > DTS... that probably explains it. > > So have to recreate the catalog... > > -----Original Message----- > From: Nick McClure [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 26, 2006 9:53 AM > To: CF-Community > Subject: RE: SQL 2000 Full Text search question. > > Are you using a DTS to copy data, or the structure also? > > If there is a change in structure then it will break a full text catalog. > > > -----Original Message----- > > From: Jacob [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, April 26, 2006 12:52 PM > > To: CF-Community > > Subject: SQL 2000 Full Text search question. > > > > I have a two SQL 2000 servers (test server and live server) with two > > tables > > that have full-text searching capabilities. > > > > > > > > When I transfer the tables from my test SQL server to live SQL Server > > using > > DTS, it kills my catalogs on the live server. I have to re-create the > > catalog and repopulate. > > > > > > > > Any reason for this or is this by design? > > > > > > > > Thank in advance. > > > > Jacob > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:5:205505 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
