View Help get SQLPS Open Sourced and on GitHub.txt
https://connect.microsoft.com/SQLServer/feedback/details/2442788/open-source-sqlps-and-publish-code-on-github |
View Get-AutoCreateStatsInfo.ps1
# Code answers from Session Q & A (http://powershell.sqlpass.org/SessionQA.aspx) | |
[void][Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.SMO") | |
$sqlservers = "sqlserver2014a","sql2012-esx" | |
foreach ($sqlserver in $sqlservers) { | |
Write-Output "Connecting to $sqlserver" | |
$server = New-Object Microsoft.SqlServer.Management.Smo.Server $sqlserver | |
foreach ($db in $server.databases) { | |
if ($db.AutoCreateStatisticsEnabled -eq $false) { |