Add to Technorati Favorites
Welcome to ThePowerShellGuy.com Sign in | Join | Help

Browse by Tags

All Tags » SQL Server   (RSS)

listing all the Databases from a SQL Server from PowerShell

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
Posted by MoW | 0 Comments
Filed under: ,

PowerShell get-SqlServerList

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
Posted by admin | 3 Comments
Filed under: , ,