Viewing 15 posts - 1,681 through 1,695 (of 1,790 total)
select datename(month, getdate()) will get you the name of the month. If you need to use case it could look like
case
when datepart(month, getdate()) = '01' then 'January'
when datepart(month, getdate())...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 13, 2001 at 12:07 pm
I have spent more time than I care for in the SMS database trying to retain where MS is storing pertinent data and it is extremely confusing to say the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 13, 2001 at 7:12 am
I'm assuming you are using a Execute SQL task or a transform data task and if so, I believe you still have to have a linked server in order to...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 11, 2001 at 7:15 am
One question I would ask would be what jobs are running throughout the day that could potentially cause memory munching? I have seen Mail tasks eat memory quite efficiently and...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 11, 2001 at 7:02 am
I realize that this is a migration related document but, if you can understand what it takes to migrate, you should be better off in understanding how they compare. Hope...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 11, 2001 at 6:52 am
Do you mean case?
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 7, 2001 at 1:16 pm
I don't know if you guys are intentionally teasing this poor gentlemen but, he wants to go FROM SQL SERVER TO ORACLE.
Bad enough that he is going the wrong...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 7, 2001 at 1:12 pm
Phill,
It should not be SQL having a problem running it from xp_cmdshell. Anything that you can run from a cmd prompt, it can run from through xp_cmdshell.
A couple more...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 7, 2001 at 7:02 am
That error is usually associated with an invalid or an inaccessible path. Is it possible that some other backup application has the drive space access limited during these times? Just...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 6, 2001 at 3:23 pm
You can actually wrap the whole path in double quotes and that will take care of the problem.
ex: "C:\Program Files\Testing\Testing One\One.exe"
Ultimately you should be able to take the...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 6, 2001 at 7:21 am
Alright Andy - I'm reading your articles on DMO and am now thoroughly convicted to do SOME work that way.
Thanks for the laugh Steve!
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 4, 2001 at 3:15 pm
I didn't have any issues in Beta either.
I did read that you can't install using WTS right now so I am holding off until I can research that out....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 4, 2001 at 3:09 pm
What you mean Oracle doesn't provide easy to use tools to migrate from SQL Server to their DBMS? I'm surprised. Seriously. I figured it would be a two way street....
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 4, 2001 at 3:02 pm
You can use isnull(ColName, '') BOL covers this with a great deal more detail. Hope this helps.
David
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 4, 2001 at 10:12 am
Agree with Steve completely. I have been functioning as a full time DBA (part time doing other tasks prior to this) for less than a year and I believe that...
David
@SQLTentmaker“He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot
December 4, 2001 at 7:47 am
Viewing 15 posts - 1,681 through 1,695 (of 1,790 total)