Viewing 15 posts - 3,481 through 3,495 (of 7,631 total)
GSquared (3/9/2009)
RBarryYoung (3/7/2009)
As Woody Allen once said:"I'm not sure I want to join any club that would have me as a member."
Either he stole that one from Groucho Marx,...
[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]
March 9, 2009 at 9:16 am
By the way, If you really want to put the XML in your post, you can use one of the following methods:
* Replace all "<" and ">" with "["...
[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]
March 9, 2009 at 8:50 am
What have you tried? And what has happened when you tried it? (tell us the error message if there is one)
[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]
March 9, 2009 at 8:36 am
Good point, Jack. I had assumed that CaseID was Ok in the table since it appears to be set by the procedure, but it's not necessarily so. Best...
[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]
March 9, 2009 at 8:28 am
Hmmm, yeah that's quite a bit different from what I usually have to do: loading daily extracts. Very regular, very stable. Much more suited to permanent staging tables.
[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]
March 7, 2009 at 9:30 pm
It is not really clear what you are trying to do or what your question is. Please read the following article on how to get better answers to your...
[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]
March 7, 2009 at 9:10 pm
We cannot see most of you schema, because the security on these forums will filter out most text that looks like XML or HTML. Please post your XML as...
[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]
March 7, 2009 at 8:59 pm
Check for triggers on the AssetTracking table.
You may also find that you will get more responses if you bother to format your SQL code a little, like your VB code...
[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]
March 7, 2009 at 8:30 pm
The NULL is the blank line that the command shell is printing. It is not coming from SQL Server or the xp_CmdShell procedure, it is coming from DOS itself.
If...
[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]
March 7, 2009 at 8:01 pm
Jeff Moden (3/7/2009)
[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]
March 7, 2009 at 7:46 pm
As Woody Allen once said:
"I'm not sure I want to join any club that would have me as a member."
[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]
March 7, 2009 at 1:12 pm
You would need to write your own activity monitor for 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]
March 7, 2009 at 1:02 pm
GilaMonster (3/7/2009)
t.walker (3/6/2009)
I really support that idea. I think a more private invited members forum would enable me to speak more freely/
Just one question. How would you determine who's allowed...
[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]
March 7, 2009 at 8:07 am
t.walker (3/6/2009)
Although I am a rookie here, I am also a...
[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]
March 6, 2009 at 5:21 pm
GSquared (3/28/2008)
rbarryyoung (3/27/2008)
GSquared (3/27/2008)
Bob updates the order and changes the price incorrectly: UpdateBy = "Bob"
Sue updates the order and changes...
[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]
March 6, 2009 at 5:10 pm
Viewing 15 posts - 3,481 through 3,495 (of 7,631 total)