Wherever possible, the backup should have all the data required; ie all lookup tables for static drop down lists such as "status" and "state" and whatnot are in the backup.

I...

yes; a SQL Server backup is the equivilent of a dump file; the differences are it restores much faster than a dump, and it is really binary in nature; opening...

the best answer is to create a backup of the database, and restore the database, instead of trying to script it out.

I don't think you can script out a TEXT,...

if you pass zero to a date time field, it is a valid date. that date is 1900-01-01 00:00:00.000 of course, so i think your foxpro database has zeros for...

use this script from the contributions, and change the where xtype='U'

to be where xtype in('U' ,'V')

http://www.sqlservercentral.com/scripts/contributions/759.asp

that will give you tables and views in dependancy order, which is the...

which user did you create? rep_process or rep_user?

did you create only one but both need to exist?

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