Hiya,

What this code should do is look at the results of

"SELECT *

FROM win32_service

WHERE name LIKE '%SQL%'

OR name LIKE '%MSOLAP%'

OR name LIKE '%ReportServer%'

OR name LIKE '%MSDtsServer%'" `

and if...

I think I would do it in a different way but using your code I would add this in

if($Srvc.count -eq 0)

{

Write-Host "SQL Not Installed on $Server "

}

else

{

Write-Output ("Server: {0}" -f...

I love Powershell

[void][reflection.assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo");

$Server = "ServerName";

$srv = New-Object -TypeName Microsoft.SqlServer.Management.SMO.Server $Server

$srv.Mail.Script();

I have a PS script that interrogates JobServer.Jobs on all servers across my estate at 7am.

So when I come into work it has emailed me a single email for each...

Hi

This is fabulous. Thank you very much for making it available to us.

I am having a couple of problems with this script. Please excuse any obvious newbie errors (but point...

Its 8 for databases for our main production database

Main Production System

Production Support

QA

UAT

Dev

Internal Training

External Training

and a nightly refreshed Reporting DB

If you include backups

3 x Nightly Full backups on Disk for each...