if it's a test database, you should be able to get another copy from production, right? you do have access to backups, right?

if not, your only hope is that you...

someone recently had trouble with FT where a very vanilla statement no loner worked, but worked on other servers with same data/config.

reinstalling all the patches did the trick;

at a minimum,...

i was wondering how this new guy was beeting Remi to the punch/post; must be that Remi-bot we heard so much about.

Seriosuly, thanks...

umm...SQL Server 2000 books online: there's a section called What's New that lists everything relavant in glorious detail.

if you don't have SQl 2000 installed, you can search the knowledgebase for...

i'm sorry; i would try some lame ideas like changing  the definition of @SearchKeywords char(30) to Varchar like in the example; i'll keep looking, but i dno't see what the...

the example from BOL clearly shows an example with a variable similar to what youy are doing:

USE pubs

GO

DECLARE @SearchWord varchar(30)

SET @SearchWord ='Moon'

SELECT pr_info FROM pub_info WHERE FREETEXT(pr_info, @SearchWord)

does this database...

in the "other" database which was your original source for the [PM] data, is the information all together is a larger table?

can you post the schema of the source...

ok much better. you still should have provided real table names instead of examples.

since you are inserting into two tables at run time, you'll want to do this with a...

here's a script to find all columns by datatype that might help:

select sysobjects.name as TblName,

syscolumns.name as ColName,

type_name(syscolumns.xtype) As DataType

--into #FKFinder

 from sysobjects

inner join syscolumns on sysobjects.id=syscolumns.id

where sysobjects.xtype='U'

and type_name(syscolumns.xtype)='datetime'

--datatypes

the NOT FOR REPLICATION option is used to handle incrementity IDENTITY values on primary keys.

here's my contribution to drop only foreign key contraints; i'm ignoring all other types of constraints...

make sure SET NOCOUNT ON is at the top of your stored procedure; if it's not there, your ADO recordset may be getting the results of

 "(45 rows affected)" or something...

FWIW, i've used a variety of firewire and USB devices; any firewire or US device that had an external power supply always worked fine for me, but most backups I...

you keep dancing around the issue i think; does the foreign key in table two already exist? i think not. does the data exist in another table and you are...

it would help if you could show the schema of the tables in question; then you'd get a solid answer from one of the readers here.

In theory, you simply add...

your right; i could see how making any assumption like this could come back and haunt you forever;

I've been similarly nailed in assuming that a blank city could be...