This might seem obvious but your execution policy is set to remotesigned? Also you may want to just run Write-SmoToCsvFile.ps1 and pass in the server name instead of using...

maneffa (10/23/2008)

---

cmille19 (10/22/2008)

---

Thanks for the updated info, I wasn't aware R2 changed the max memory. Do you know if clustering is supported in Windows 2003 R2 Standard? It wasn't in...

Thanks for the updated info, I wasn't aware R2 changed the max memory. Do you know if clustering is supported in Windows 2003 R2 Standard? It wasn't in Windows 2003...

One other correction, the article states:

"...differences between a say 32 bit 2 GB RAM SQL2000 Standard on NT4 Server and a 64 bit 32 GB RAM SQL2005 Standard on W2K3...

When I need to execute a query with parameters I just create a PowerShell script for that specific purpose and load LibrarySmo at the beginning of the script. Here's a...

So at this point your job is completing and successfully loads the data and archives the csv files, but it does not include job step output information in the job...

Have you had a chance to try this fix?

cmille19 (10/8/2008)

---

I see a mistake in the article where I set the archive and data directory to the same directory. Here's what...

It doesn't seem like you can run PowerShell through SQLCMD. I just tried running !!powershell -version and all I see are unprintable characters. I often run PowerShell through SQL Agent...

I see a mistake in the article where I set the archive and data directory to the same directory. Here's what I have in my production script Write-SmoCsvToDb.ps1:

$CsvDir = "$scriptRoot\Data\"

$arcDir...

Check the "Advanced" page under the job step "Run-SmoToCsvFile" and ensure the path to the SQLPSX.err output file exists. This is one difference between the command-line and SQL Agent execution...

I consider using PowerShell or for that matter VBScript or Perl when I need to pull data from many SQL Servers, or need to implement a scriptable/repeatable solution (which excludes...

All,

I've completed a part-time 9 month project to write a utility called "SQL Server PowerShell Extensions (SQLPSX) which uses SMO, PowerShell, and SSRS to produce permissions/security reports including effective...

One other feature with SQL 2008, which is seldom mentioned is the new multi-server query in SSMS 2008. This is a really useful feature where you can run a query...

I noticed the same thing, I'll follow up with the site owners, as it appears be a problem with their script editor. I'm able to reproduce an issue where multiple...

Please post the contents of your sqlem.ps1 file