# encoding: utf-8 # api: powershell # title: Show Databases on server # description: ############################################################################################# # version: 0.1 # type: function # author: Rob Sewell # license: CC0 # function: Show-DatabasesOnServer # x-poshcode-id: 5556 # x-archived: 2015-05-04T22:26:05 # x-published: 2015-10-31T02:46:00 # # # # NAME: Show-DatabasesOnServer.ps1 # AUTHOR: Rob Sewell http://sqldbawithabeard.com # DATE:22/07/2013 # # # COMMENTS: Load function for finding a databases on Server # ———————————————————————— # ############################################################################################# # # NAME: Show-DatabasesOnServer.ps1 # AUTHOR: Rob Sewell http://sqldbawithabeard.com # DATE:22/07/2013 # # COMMENTS: Load function for finding a databases on Server # ———————————————————————— Function Show-DatabasesOnServer ([string]$Server) { $srv = New-Object ('Microsoft.SqlServer.Management.Smo.Server') $server Write-Host " The Databases on $Server Are As Follows" $srv.databases| Select Name }