i never had a chance to test the script and was always afraid to run it for real at 2am. so we always did it manually.

to speed things up i...

i've never done it, but what you can do is set up a transformation to write all bad imports to a table to be worked on manually

the explanation is in...

yep, i think that's what it's called

i had to recreate my import process a few weeks back and i went through each table, looked at the column lengths and created...

if this is between 2 sql servers try to set DTC to run under a domain account that has SQL rights on each server

idiot auditors said we had to get...

i do monthly imports of taxation data from CCH and have had a similar problem

only solution i ever found was to map out the column lengths

our reporting DBA's usually write huge stored procedures with a lot of CASE statements for these things or multiple stored procedures and functions with CASE statements from the master calling...

are you using XA drivers?

i want to play with this in detail when i have time, but we had a problem with an app with similar conditions

we have a table with data and need...

you need A records for each of the physical hosts, each SQL instance, the cluster IP and if you run Windows 2003 then the MSDTC IP as well

majorbloodnock (12/21/2007)

---

Jason Shadonix (12/20/2007)

---

If your vendor says his app is only 2000 compatible, I wouldn't mess with putting it on 2005, even if that DB is in 2000 compatablity mode....

the big compatibility problems i've always had was backup software

Veritas Netbackup will only work with the SQL server it is designed for. we had to upgrade before we moved to...

sql 2000 had a 64bit version, but not sure if there there was a 64bit AS for sql 2000

if your PHB does not buy another machine, be sure to thank...

how much data and how often does it change?

i have some data i import from a few sybase db's daily and we just do a full copy and replace every...

just connect to the SQL 2000 server with SSMS to set up replication. no law says you have to use EM

try to run backup log with no_log to clear the log and than try it