Blog Archives

T-SQL Tuesday #39: Getting Installed Instances, querying logs

This week’s T-SQL Tuesday is being hosted by Wayne Sheffield, and the topic is to blog about anything PowerShell related to SQL Server.
Today I am going to write about a few things:
-Getting a list of installed instances on a particular box.
-Reading the SQL*Server error logs using SMO.
-Querying the Windows event logs for errors.

Tagged with: , , , , , , ,
Posted in PowerShell, SQL Server