I will throw in some extra stuff here.

1) There are some simple checks you can do without LUHN such as

VISA starts 4

MasterCard starts 5

Discover starts 6011

Lenghts are standard

2) You are...

sp_removedbreplication

Yes but I also don't recall having to use it during the install. You just have to be able to account for the number of running instances as being licensed.

Sounds resonable as long as it meets your needs and as long as the DB1 items are getting all the way thru to DB3. And as lonng as you have...

Same user account used for both runs?

I don't recall any limit to the number of objects that can exist in the database except in the case of MSDE (Desktop Edition) which was a DB size limit...

I would also suggest UNION ALL instead of UNION as duplicates are deleted from the resultset with just UNION

Meaning if

TableA = 100

TableB = 283

TableC = 100

You will get the result...

There are a few way you could approach, my first thought is using a prebuilt query in the syntax of the origin system that uses date filed minus 1-2 months...

I would agree with Ed, unless a seperate array on a seperate controller ( or at least on a different channel on the same) you won't in most cases see...

Direct from MS

If you edit a noise-word file, you must repopulate the full-text catalogs before the changes will take effect.)

http://msdn2.microsoft.com/en-us/library/aa172881(sql.80).aspx

Most common issue I see that casues this type of issue is that when a person creates an object in VB and ASP they forget to do proper cleanup.

Make sure...

What type of DTS object are you using for the imports?

Try limiting the data further. It may be the column datatype is being mistranslated do to a variance in the data. What I am meaning is that if say you...

How did he extract the binary from the system. I suspect he exported it incorrectly probably the wrong mime type.

Here is an example of a BMP and C# from MS...

Yeah, but decimal(30,20) works perfectly in the examples.

511.9400

512.9400

578.9400

654.9400

655.9400

3.0200

3.0100

3.0200

3.0400

3.0500