Viewing 15 posts - 1,576 through 1,590 (of 7,636 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).
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...
September 11, 2009 at 11:25 pm
And I guess that makes Wesley Brown, SSC's "Original OP". 😀
September 11, 2009 at 11:02 pm
Hah! I even know where the very first thread (still existent) is. 😛
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...
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...
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...
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...
September 11, 2009 at 4:55 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...
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...
September 11, 2009 at 2:23 pm
Where are you defining and instantiating @objQueryResults? You cannot call methods until you have an instantiated object.
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
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...
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! ...
September 9, 2009 at 9:41 am
Viewing 15 posts - 1,576 through 1,590 (of 7,636 total)