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

our devs would write code in 2000 which would look like

select col1, col1 from some_table order by col1

why they did this, no one knows. but it broke in sql 2005...

if you have EMC SAN's just use SRDF. we mostly go R/O when we have several hours of downtime and R/W when there is a few days, like when we...