Just 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.
