Powershell. Have you taken a look at the EPM project?

http://www.codeplex.com/EPMFramework

Just FYI -

"

Q: What exactly is a processor license and how does it work?

A: If you have made a processor inaccessible to all operating system copies on which...

jinx8402 (12/14/2009)

---

Is it possible to limit SQL to use only one cpu (one multi-core processor rather than both processors)? Will this affect licensing costs?

I know and understand performance will...

NP - Correct 🙂

Refer to KB897615 regarding the MS Policy -

http://support.microsoft.com/kb/897615

This thread might offer some assistance -

http://social.msdn.microsoft.com/forums/en-US/sqlanalysisservices/thread/dd633c5e-fdb4-449b-a445-c13abcd6db24/%5B/url%5D

Is this a named instance or a default instance? You mentioned you that were able to connect to the instance, was this local to the server or from a remote...

None to the best of my knowledge; a witness can monitor multiple mirrored sessions.

are your looking for something like -

declare @XmlTest table

( ID int identity(1,1), LineXml xml)

insert into @XmlTest (LineXml)

values

('

<Root>

<LineItem>

<LineItemReference>30044</LineItemReference>

</LineItem>

<LineItem>

<LineItemReference>30045</LineItemReference>

</LineItem>

</Root>'),

('

<Root>

<LineItem>

<LineItemReference>30046</LineItemReference>

</LineItem>

<LineItem>

<LineItemReference>30047</LineItemReference>

</LineItem>

</Root>'),

('

<Root>

<LineItem>

<LineItemReference>30048</LineItemReference>

</LineItem>

<LineItem>

<LineItemReference>30049</LineItemReference>

</LineItem>

</Root>')

select ID,LineXml.value('(/Root/LineItem)[1]', 'int') as Line

from @XmlTest

union

select ID,LineXml.value('(/Root/LineItem)[2]', 'int') as Line

from @XmlTest...

Regarding performance counters, Lock Wait Time (ms) and Lock Waits/sec should offer some more insight into lock escalation issues;

Lock Wait Time (ms)

Total wait time (milliseconds) for locks in...

kolb.branden (12/9/2009)

---

I am trying to run DTEXEC from a command entry screen as follows (this is the simple try...once this is running I'll add more parms and see if I...

NP. It is my understanding that the OLEDB provider for Microsoft Directory Services doesn't expose the page size property....I'm pretty sure I've seen this logged as a feature request on...

dpt (12/9/2009)

---

Thanks. I'll look into that.

I found another way that seems to be the easies - what about setting up an alert in the SQLServer:Locks object? Are you...

There was an article posted to SSC today regarding this; check out the comments section. It was suggested that this setting is configurable in AD and an alternative was load...

shew (12/9/2009)

---

Tommy Bollhofer (12/9/2009)

---

Have you attempted to re-associate the file type via windows explorer? Right-click the *.sql file in windows explorer and select properties. Click the change button under opens...