Get List of User Databases from SQL Server - SQL Server Tutorial

Published: 20 February 2015
on channel: TechBrothersIT
25,807
74

In this short quick post we will learn how we can get the list of all user Database from SQL Server. SQL Server provided different system views those can be used to get information about objects present in SQL Server. To get list of all databases we can use sys.databases view that provides name of databases with other properties such as recovery model, state_desc,compatibility level etc.


link to post for scripts used in this video : http://sqlage.blogspot.com/2015/02/ge...


On this page of the site you can watch the video online Get List of User Databases from SQL Server - SQL Server Tutorial with a duration of hours minute second in good quality, which was uploaded by the user TechBrothersIT 20 February 2015, share the link with friends and acquaintances, this video has already been watched 25,807 times on youtube and it was liked by 74 viewers. Enjoy your viewing!