Archive for April 2011

Get all Fulltext catalog paths on a SQL Server

On some of our SQL Servers the Fulltext catalog locations are not excluded from anti-virus scans so I was after an easy way to get this information quickly. Once again Powershell proves its worth! Just change the variable $server to query a particular server. The script will list all fulltext catalogs on the instance. ?View […]

Quickly audit the edition of multiple SQL Servers

Today I needed to quickly audit the edition of all our active SQL Server machines. This is a snap with a little bit of Powershell. Just execute the below code, replacing the names of each sql instance as appropriate. ?View Code POWERSHELL$sqlservers = @("sqlserver1", "sqlserver2", "sqlserver3", "sqlserver4", "sqlserver5", "sqlserver6", "sqlserver7"); # Load smo [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SqlServer.Smo") | […]