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