Viewing 15 posts - 3,151 through 3,165 (of 7,631 total)
Ah, okay. I suppose that didn't come up for me because I was using them for scripting and I just used the "dependent objects" trick to get them.
[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 30, 2009 at 8:47 am
dlongnecker (3/30/2009)
My mistake RBarryYoung, I tackeld the wrong argument.
s'alright. 🙂
Preaching the evil of cursors then using them yourself for particular instances can be a mixed message for neophytes....
[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 30, 2009 at 8:42 am
More generally, the OUTPUT parameter modifier does not prevent them being used for input also.
[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 30, 2009 at 8:27 am
Here's a shortcut way to deal with the namespaces problem:
SELECT CAST(CAST(XMLMessage as VARCHAR(MAX)) AS XML).value('(//*:DocOrgName)[1]', 'NVarchar(50)')
, CAST(CAST(XMLMessage as VARCHAR(MAX)) AS XML).query('(//*:DocOrgName/text())')
from DocumentSource
[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 30, 2009 at 8:22 am
cspencer (3/30/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 30, 2009 at 8:11 am
dlongnecker (3/30/2009)
A one time use/db script probably isn't going to take the server down.
The probability of overfilling an...
[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 30, 2009 at 8:02 am
Krushna (3/30/2009)
RBarryYoung (3/28/2009)
OK, and what happens when you execute this yourself in a Query windows?:
xp_cmdshell '\\192.10.10.245\E:\PrintToPDFConsole.exe'
It was showing :
The network path was not found.
But after I've changed it to 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 30, 2009 at 7:45 am
The real hard part was figuring out how to spell the tag labels. They're case-sensitive and not generally capitalized the same as they appear above.
[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 30, 2009 at 7:29 am
Do view source on any forum page and look at the js "Brush" modules right at the top:
<script type="text/javascript" src="/shared/syntaxhighlighter/scripts/shCore.js"></script>
<script type="text/javascript" src="/shared/syntaxhighlighter/scripts/shBrushCpp.js"></script>
<script type="text/javascript" src="/shared/syntaxhighlighter/scripts/shBrushCSharp.js"></script>
<script type="text/javascript" src="/shared/syntaxhighlighter/scripts/shBrushCss.js"></script>
<script type="text/javascript" src="/shared/syntaxhighlighter/scripts/shBrushJava.js"></script>
<script type="text/javascript" src="/shared/syntaxhighlighter/scripts/shBrushJScript.js"></script>
<script...
[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 30, 2009 at 7:20 am
Do you ever miss a login or a logout? If the answer is no, then you should be able to just count the logins and logouts and match then...
[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 29, 2009 at 9:59 pm
I think that it is just a matter of the order of the Path and Value within the key.
[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 29, 2009 at 6:48 pm
By the way, although I don't think that it is the cause of your current problem, you probably should be using SCOPE_IDENTITY() instead of IDENT_CURRENT().
[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 29, 2009 at 6:32 pm
john (3/29/2009)
PS when I reply the previous post is not visable. Is this configurable?
Also, if you want to quote the post you are replying to, then just click the "Quote"...
[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 29, 2009 at 4:37 pm
If your Inserts are fine, then you are probably OK with that many indexes. You might still use some of the prior advice to determine whether you are 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]
March 29, 2009 at 4:23 pm
good catch Jeffrey!
On my 2005 server this SQL code gives me the same error as the OP, however on my 2008 server, I get "Invalid object name 'Source'." which 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]
March 29, 2009 at 4:20 pm
Viewing 15 posts - 3,151 through 3,165 (of 7,631 total)