Viewing 15 posts - 1,576 through 1,590 (of 7,631 total)
Jacob or Steve:
There seems to be some kind of formatting problem with the code blocks over-running the text that follows them. At least for me (Chrome 2.0).
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 12, 2009 at 5:34 pm
sknox (9/3/2009)
Chirag (9/3/2009)
This is what i did
begin tryEXECUTE sp_rename N'fakename', N'fakename2', 'OBJECT'
end try
begin catch
select @@ERROR
end catch
Yes. That will catch the error as it happens. So you determined the value of...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 11, 2009 at 11:25 pm
And I guess that makes Wesley Brown, SSC's "Original OP". 😀
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 11, 2009 at 11:02 pm
Hah! I even know where the very first thread (still existent) is. 😛
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 11, 2009 at 10:55 pm
Paul White (9/11/2009)
RBarryYoung (9/11/2009)
All I could come up with was "Swine-Obliterating Moden", but that didn't seem right. 😀
I missed the hyphen on first glance and thought that the pork...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 11, 2009 at 10:09 pm
Paul White (9/11/2009)
john.arnott (9/11/2009)
RBarryYoung (9/11/2009)
OK, I give up, Bob. What does "SOM" mean? Even Google can't find a definition for me... 🙂
SOM=Spewing On Monitor. Another invention...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 11, 2009 at 9:32 pm
Bob Hovious (9/10/2009)
No, I haven't seen Spamalot...... Guess I'll need to wait until they make a movie out of it.
SOM !!!! :-P:w00t::-P:w00t:
OK, I give, Bob. What...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 11, 2009 at 4:59 pm
Grant Fritchey (9/9/2009)
Jeff Moden (9/9/2009)
Grant Fritchey (9/9/2009)
WHOOP!I'm sitting the same room as Jeff Moden. My IQ has gone up. Who needs a problem sovled?
:blush: Heh... that's odd. I...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 11, 2009 at 4:55 pm
Thanks, Matt. I needed that. 🙂
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 11, 2009 at 4:31 pm
And yes, as Jeff implies, nine times out of ten, SQLCLR is the harder (and slower) way to do something this (apparently) simple. (And that tenth time is when...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 11, 2009 at 2:27 pm
Right, if I were to guess then I would guess that you are converting or casting your date to string format without specifying an explicit format and SET LANGUAGE differences...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 11, 2009 at 2:23 pm
Where are you defining and instantiating @objQueryResults? You cannot call methods until you have an instantiated object.
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 10, 2009 at 9:57 am
Can't really tell what you are talking about just from this. You should show us your code and some examples of what you are talking about.
thnx
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 10, 2009 at 9:42 am
I assume then that you have been using the Import/Export wizard up until now?
Depending on how comfortable you are with T-SQL vs. SSIS, you might be be better off using...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 10, 2009 at 9:40 am
Silverfox (9/9/2009)
RBarryYoung (9/9/2009)
GilaMonster (9/9/2009)
GSquared (9/8/2009)
jcrawf02 (9/8/2009)
It's a shame they're not doing this with a laden swallow...Yes, but African swallows are non-migratory.
They are? Or is that a Monty Python reference?
Ouch! ...
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 9, 2009 at 9:41 am
Viewing 15 posts - 1,576 through 1,590 (of 7,631 total)