Here is a simple script to audit your SQL Server Instance Properties.
Note that the property names are not hardcoded. We query each of these properties, and use those to display the property values.
If you prefer, you can also query directly each of the properties of an instance. If this is the case, just specify your server object and then the property name. For example:
$serverObject.BackupDirectory
The list of properties can be found at the end of the post.
Read the rest of this entry »
1 Comment
