Something I wrote up years ago, not sure if you tried this but could not hurt to post:

To connect to Integration Services on a Remote Server
...

That script worked to get the naming of the server that would work in the script. Thank you so much..

I am using a script I found on toadworld:

http://www.toadworld.com/platforms/sql-server/b/weblog/archive/2012/10/10/using-powershell-to-run-queries-against-central-management-server.aspx

just trying to get it to work with my CMS server which has an Instance name.

Here is the script as...

Here is what I am getting if I use a single quote around the server and instance name:

Get-ChildItem : Cannot find path 'SQLSERVER:\SQLRegistration\Central Management Server Group\'Server\InstanceName'\NonProd

\Dev' because it does not...

This is being ran on SQL 2008 R2

All I am getting back when I run the test script is : The operation completed successfully

On the other instances I am getting...

Thanks Shawn... Believe it or not my friend was contacted yeaterday and he received his Money Back...

Well I feel like the training is worth the money.. I guess my hangup is that I am paying them an extra $200 for nothing more then it is a...

I was in the process of saving enough money to buy the 70-432 from CBT Nuggets and looked at their website today and the price for the DVDs have jumped...

I agree with the hands on experience.. I have been a hands on Jr. DBA for 3 years now.. Just looking to learn something new that I don't get in...

Thanks for the suggestions.. I have looked at both and it looks like CBT Nugget is the way I am going to go. Cost less and has more hours... I...

Thanks John, Yeah that would be jobs that run before 7am... So 6:59:59 would be the ending point and I have another job that would pickup at 7:00:00 and that...

This does work if I run the job at 7am.. But what if I run the job at 10am or 1pm... I still only want the jobs that ran between...

I found a solution...

$SqlQuery = "select " + $SqlServer + ",DatabaseName,TableName,Rows from Zero_Data_Tables"

Thanks Gail... This looks like what I was looking for...

I am currently reading SQL Server 2005 Unleashed from cover to cover to get a full understanding of everything that could happen with the sql server and to see were...