Viewing 15 posts - 3,181 through 3,195 (of 7,636 total)
RBarryYoung (3/17/2009)
Ugh. Not good. I'll have to use the...
March 28, 2009 at 11:41 am
"Quote" my post and you will see it in the code tag.
March 28, 2009 at 11:24 am
Derek Dongray (3/26/2009)
RBarryYoung (3/26/2009)
A lot of the issues seem to have been fixed, so thanks for that.I can't see any change.
Well, for one thing we can post and see XML...
March 28, 2009 at 10:45 am
Post it like this, Florian!
class Program
{
static void Main(string[] args)
{
...
March 28, 2009 at 10:40 am
OK, and what happens when you execute this yourself in a Query windows?:
xp_cmdshell '\\192.10.10.245\E:\PrintToPDFConsole.exe'
March 28, 2009 at 9:41 am
What command did you execute that returned this error?
March 27, 2009 at 12:22 pm
enzomenoni (3/27/2009)
March 27, 2009 at 11:05 am
Roy Ernest (3/27/2009)
It will eat up your output Buffer resource if I am not mistaken. PRINT Statements can be seen only on the SSMS window. So why keep it?
Actually...
March 27, 2009 at 10:53 am
Having done both, I cannot imagine that Replicating all of the tables in a database would be less work and less maintenance & overhead than Log Shipping.(!) If you...
March 27, 2009 at 10:34 am
SQLBOT (3/27/2009)
We're not seeing disk waits in SQL at event time, and SQL File I/O rates are normal during the event (actually below average in some cases).
How are you determining...
March 27, 2009 at 10:02 am
Nulls probably indicate that you are misspelling the tag names. Remember that XML is case-sensitive.
March 27, 2009 at 9:45 am
SQLBOT (3/27/2009)
RBarryYoung (3/26/2009)
SQLBOT (3/26/2009)
Any advice on where to go next?What are the individual physical disk's %Idle, before & during?
Thanks for your response, sir.
Interestingly enough, physical and logical disk utilization spikes...
March 27, 2009 at 9:19 am
GSquared (3/27/2009)
March 27, 2009 at 9:08 am
Both of these should work then:
SELECT CAST(CAST(XMLMessage as VARCHAR(MAX)) AS XML).value('(/CData/DocumentOrganisationName)[1]', 'NVarchar(50)')
, CAST(CAST(XMLMessage as VARCHAR(MAX)) AS XML).query('(/CData/DocumentOrganisationName/text()')
from DocumentSource
March 27, 2009 at 9:03 am
Viewing 15 posts - 3,181 through 3,195 (of 7,636 total)