It depends on what you're intending to support after passing the exams but I would go for the 2012 exams at this point.

Think of the overhead you'll be asking every other developer that work not only on this package, but also others that need this same checkpoint-like behavior. It's going to become...

Do not enable xp_cmdshell! You do not need it for this scenario and it introduces risk in your environment.

If you want to do everyting with T-SQL use...

I would grab a copy of XML Spy and try mapping it. It's a pretty robust tool and could probably get you your XSLT pretty fast.

CREATE TABLE #LOGSPACE

(

DB SYSNAME,

LogSize FLOAT,

SpaceUsed FLOAT,

Stat BIT

);

INSERT INTO #LOGSPACE

(

...

No need for an extra step really, if all you want to do it restart that step should it fail. In the job step you can set the Retry attempts...

GilaMonster (9/25/2012)

---

No, there doesn't have to...

I am still unclear about your concern. In the data? Or in between the markup tags?

Like this:

<root><element>1

2

3</element></root>

Or like this:

<root>

<element>123</element>

</root>

GilaMonster (9/25/2012)

---

opc.three (9/25/2012)

---

To be clear sa is...

XML is not format dependent. Any whitespace produced in between markup is strictly for us humans. All XML parsers are going to strip that out (i.e. ignore it). What are...

I haven't used it so am not sure it fills all your requirements but it sounds like using a Multi-server Agent Job may work for you:

Automated Administration Across an Enterprise

sestell1 (9/25/2012)

---

opc.three (9/25/2012)

---

To be clear sa is...

Perry Whittle (9/25/2012)

---

opc.three (9/25/2012)

---

I realize that. That is my motivation for adding in the coulmn that implies it is the amount of memory allocated as a locked page, i.e. AWE...

You're welcome. Happy you got it sorted.

As I said though, "Unicode" = UTF-16LE. I was saying to try the input file in UTF-32 format. Something like this would have created...

Perry Whittle (9/25/2012)

---

opc.three (9/25/2012)

---

I didn't think locked pages were part of the working set which is why Task Manager lies to us but maybe locked_page_allocations_kb is not what I am...