Viewing 15 posts - 811 through 825 (of 1,195 total)
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?
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 11, 2013 at 5:14 am
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 8, 2013 at 1:51 am
Damn it! I should have listen to my teachers mantra "read the question through before trying to answer"
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 8, 2013 at 1:12 am
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 7, 2013 at 3:34 am
Thanks for the reminder of performance characteristics v exec plans - my bad memory
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 7, 2013 at 3:15 am
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 -...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 7, 2013 at 3:11 am
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 7, 2013 at 3:04 am
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 6, 2013 at 8:59 am
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 6, 2013 at 8:37 am
niladri.primalink (3/5/2013)
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 5, 2013 at 6:56 am
Beatrix Kiddo (3/5/2013)
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 5, 2013 at 4:03 am
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 5, 2013 at 3:39 am
Very good question Demonfox - thanks.
Took four re-reads and two cups of coffee before getting my point this morning
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 5, 2013 at 1:46 am
Nice and gentle start to the week - thanks
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 4, 2013 at 1:27 am
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...
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 1, 2013 at 4:14 am
Viewing 15 posts - 811 through 825 (of 1,195 total)