Is the "Z" drive on the server or is it a mapped drive on another machine?

If I'm not mistaken, a friend of mine ran into the same problem.

After search the internet, I believe he found out that this is caused by a BUG.

If the table have keys that uniquely identify the rows then you do not need to use row by row logic.

Run a query that returns a list of rows that...

Can't you use the REPLACE function when specifying that field to replace spaces with nothing?

Connect as? Oh I hate and love that. Hate that I have to use it but love that it is available.

If you running the DTS manually, you...

There are numerous reasons why you may be getting that error. I'm not an expert on network security so I'm going to stay clear of that one.

One option that...

My thought is to go for the SQL 2005 first then you can try the upgrade exam to 2008.

After reading:

"Returns the current database system timestamp as a datetime value without the database time zone offset."

I thought there would be a difference, because of the reference to the...

Which one should you use?

Simple, look at both values and you'll see the difference. I guess the correct answer to your questions is that it depends what you want...

It was so easy that I went to the trouble of looking it up to be sure it wasn't a trick.

Irish Flyer, 1434 is not a default for SQL 2000.

I don't know the answer to your problem but it does remind me of setting up the import of a few files using SSIS.

I hope they add the ability to...

try: convert(char(8), DateField, 112)

replace DateField with the field that holds the date.

I think you have to approach this issue from 2 side.

#1 - I agree with the previous post about training. With the training should come a clear...

I'd be tempted to start with correcting the compatibility level, then re-indexing, one index at a time. It has the potential for immediate payback.