thank you!

execution policy was set correctly.

I resolved this issue by fully qualifying the path the powershell.exe

Thanks for your thoughts though!

Thanks for the reply, I'll take a look, but the user is an admin on the server

it looks like its a windows installer 2.0 issue. Implemented on windows server 2003

http://anotherlab.rajapet.net/2008/05/ack-windows-installer-does-not-permit.html

If you feel like it, I'd love to see it. We're really only talking maybe 200 records though. I had initially created the server table as simply a...

So I'm realizing that i'm probably just redefining the @wrkingDrive variable to be equal to @drive.

This got me thinking to declare a variable to house the entire update...

This might not get you 100%, but it can take inventory of sql server systems over your entire network. It will create reports based on sql server versions installed...

Thanks sean.

Lowell, the primary key would be on the date plus two other columns.

The scenario is capturing statistics for databases and a daily basis. The primary key would be...

Is there a way to execute a query on a CMS through...

If the data collector can only collect from SQK 2k8 servers than that won't work for considering the number of 2005 and 2000 servers still running.

I'm actually doing something similar....

Thank you, I will look into it

Does this show you the actual start time of all databases? What if one database goes offline?

ALZDBA Your solutions is certainly simpler and warrants looking into. Is there a way to incorporate that to look at individual databases as opposed to singluar servers?

Drew...

It looks like if I insert the first parsed field into another temp table, I can slice the right part off.

Thank you so much!