I think the key part is here:-

""xp_create_subdir() returned error 3, 'The system cannot find the path specified.' "

Does the sql agent have access to this drive?

Another thought as well for you - which do you think is the least impact on your server when running a couple of million rows

SELECT

col1 *1.02679

FROM tablea

or

SELECT

CONVERT(MONEY,REPLACE (col1,'$',''))*1.02679

FROM...

Damn it! I should have listen to my teachers mantra "read the question through before trying to answer"

Remote working doesn't work for me at the moment.

I don't have an office at home where I can lock my self away, with my wife working part time and kids...

Thanks for the reminder of performance characteristics v exec plans - my bad memory

What is the error you are getting?

Have you checked the file you are trying to load to make sure that there is nothing in there that causes the error -...

From the above (and Gails article) it looks like "in" has the advantage.

I'm not dissenting with any previous replies, but personally I would check the results before changing any production...

I feel your pain with this.

I have tried different approaches with this and the most effective one for where I work is to say to "the business"

yes I can make...

Have you checked SQL agent is running ?

If it isn't have you checked the logs to establish why not?

Best bet after that is to google your error - there may...

niladri.primalink (3/5/2013)

---

Then I need to take others help as the database is on Other server then I need to ask that person to take the back up and also will...

Beatrix Kiddo (3/5/2013)

---

Congratulations, first off!

Your reaction to leaving your job of 10 years is understandable. Everybody doubts themselves when they start a new job, everybody. You spend the first 6...

How are you trying to move the database ?

Copy database wizard?

copy a backup across and restore ?

SSIS package to copy the data across?

Or something else.

Any more information you can supply...

Very good question Demonfox - thanks.

Took four re-reads and two cups of coffee before getting my point this morning

Nice and gentle start to the week - thanks

Like a lot of questions - the answer is it depends - we can't see the table structure you have there.

Please read the link in my signature for how to...