Viewing 15 posts - 946 through 960 (of 1,348 total)
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...
December 27, 2007 at 1:36 pm
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...
December 27, 2007 at 1:33 pm
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...
December 27, 2007 at 11:12 am
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...
December 27, 2007 at 11:10 am
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
December 27, 2007 at 10:31 am
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...
December 27, 2007 at 9:44 am
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...
December 26, 2007 at 1:29 pm
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
December 21, 2007 at 9:55 am
majorbloodnock (12/21/2007)
Jason Shadonix (12/20/2007)
December 21, 2007 at 9:53 am
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...
December 21, 2007 at 9:50 am
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...
December 18, 2007 at 5:30 pm
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...
December 18, 2007 at 8:19 am
just connect to the SQL 2000 server with SSMS to set up replication. no law says you have to use EM
December 18, 2007 at 7:27 am
try to run backup log with no_log to clear the log and than try it
December 18, 2007 at 7:26 am
Viewing 15 posts - 946 through 960 (of 1,348 total)