|
|
Browse by Tags
All Tags » PowerShell » SQL Server
-
I was reading this thread http://web2.minasi.com/forum/topic.asp?TOPIC_ID=25963 , that discusses retrieving a list of databases from SQL server and a query was used.
There is also a Stored procedure available in SQL server to list all the databases, as I needed this before I had this code handy,
$Server = 'W2008'
$sqlCon ...
-
A handy onliner Function to get a list of SQL servers I have in my Profile function get-SqlServerList {[System.Data.Sql.SqlDataSourceEnumerator]::Instance.GetDataSources()} This function retrieves a DataTable containing information about all visible SQL Server 2000 or SQL Server 2005 instances.
PoSH> function get-SqlServerList ...
|
|
|