Jacob - Many thanks! That seemed to get me where I wanted to go...many thanks!

The final query looks like this:

-- shows which users are in which RG pools

SELECT es.session_id,...

Cold: Many thanks for the reply! You provided me with some good information. I'm very curious about how you've got your infrastructure for the SAN wired...

Steve - It seems like my wife and I take one "big" vacation (of 2 weeks) every other year or so, and will take a one week in between. ...

A million "thank you's" to you George!

Selecting the correct installation option made the difference. Setup is rolling through it all now. I hadn't looked at it as a...

Yeah George, I've been trying to get an SSRS instance tied into my Staging database.

I jumped on a RDC session to my Node02 machine and ran the SQL Server setup...

Yes Dan, it can be made highly available by installing SSRS on both nodes and then pointing it at a database contained within the clustered drives.

George - thanks for the...

many thanks for the advice Pizza!!!

I will give that a try and ping back here to let you and others know the results. It usually takes me a week...

True dat Benjamin, but you can click an option to hide that VM Tool icon in the sys-tray.

I was hoping that there might be a DMV which might be able...

Luis Cazares (8/29/2012)

---

Have you tried a JOIN instead of the IN?

I've read there can be unexpected problems with cross-server queries.

SELECT --USE DISTINCT if there are multiple rows in vwCRMServiceProviderAccess

SP.[ServiceProviderGuid],...

If you're intending to update two different tables like this, I think you pretty much HAVE to wrapper it in a transaction...otherwise you have a possibility of inserting or updating...

You rock Mr. Coleman! Thank you!

I looked that code over and over and never saw that those parens were missing! Sheesh!

Many thanks for your help!

Larry

okay demonfox...

I've enabled package logging and selected a small handful of events to capture and have it running now. I've examined the dbo.sysssislog and ensured that it is writing...

1 - production

1 - mirror copy

1 - reporting server

2 - test servers

2 - development servers

@6 - backup copies on SAN

Yikes!!! I hadn't really considered the number of these...