Tip: Get the list of all DBs in a SQL Server 2008
Posted in General on December 7th, 2010 by Xavier – Be the first to commentJust a quick tip on how to get the list of all databases in a Microsoft SQL Server 2008:
- Open SQL Server Management Studio
- Select master DB
- Run ‘exec sp_helpdb’
You will get a matrix of all databases created in this server. Of course, you need to have the appropriate permissions.

