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...

i think you'd need to create a job on sql server that would scan the linked server table every x minutes, and perform the new record addition when any changes...

aww come on guys; don't let the 5% of exceptions prevent you from doing the other 95% of the work.

it'd be some work gathering the data, but  a simple google...

a web page is stateless; that is the code is executed on the web server, and the results are returned to the browser. the code is executed in a milliseconds,...