Are you sure you have enough disk space? You could have large amount of uncommitted transactions.

Or the other possibility -- are you sure the servers versions are the same? ...

Finally found the real solution....by trying to correct another problem.

It is in the ODBC Administrator (ODBCAD32). Within the "Microsoft Text Driver (*.txt; *.csv)" call setup you have a Options button...

I found a solution to the problem.

The DTS was picking up the first several hundred rows as a sample. DTS then assumed they were all an Int data type. What...

One other to mention: Sometimes standards need to be relaxed.

Our standard dress code is business casual (dockers and polo shirts/dress shirts). We are all backoffice (no customers) Our hours are...

Here's a thought.

Do a backup of the DB as it currently is. Then do a restore as "New_DB" on the same server. Take a look at the tables and see...

Dumb question....but if you go in the EM and look at the Properties sheet -> Options tab, what does it say for the "Compatibility Level"?

What about spaces in the database name itself. I had a consultant come in (for another part of the IT dept), and pop a DB onto my server the was...

Then work through norecovery and restart.

Eventually one of them will work. Can you control the running of th scripts?

One thing to note is that SQL2K Standard edition only addresses 2GB of memory.

With 43 databases, you are probably hitting the 2GB limit. But it is hard to troubleshoot.

Good Luck!...

Probably, buried somewhere in the load, is a SQL Script. It may not be ovious but see if you can find it. Then edit that puppy so that the restor...

set @d_name = dbname

I think dbname will work in a transaction, but won't as a simple select.

Glad you all survived.

I'm in SW Ohio and the results sound sort of like the combo of a blizzard and ice-storm.

My personal rule of thumb is that you need to...

My apologies, I didn't qualify the #2 option.

In SQL 7 they used "trunc. log on chkpt" and something like "unlogged bulk copy" check boxes to set up how you were...

Actually, I came up with the idea in response to your question. I haven't tried it in production, but I can't really foresee...

select * from sysservers

You can always add linked servers like this where they exist as linked servers in your development environment.

sp_addlinkedserver @server = 'PrimarySvr' ,
@srvproduct = '', @provider = 'SQLOLEDB'...