List all MS SQL Server Database using T-SQL

For some purchase, you might want to show the database from your instance and you are actually could done it with just a query.

With the simply query as below, it will show all of the databases from your instances.

SELECT * FROM sys.sysdatabases

Published by

Mick Genie

Mick Genie is the founder of MickGenie.com and working at ExaBytes Network Sdn Bhd and WPWebHost web host company. He is expertise in Windows and Linux environment especially web hosting related information, tips and trick as well as the IT Information.