List All Databases in SQL Server
List All Databases in SQLÂ Server
One of the important tasks of a Database Administrator is to keep track of what databases exist on which SQL Server instances. Using the query below, you can get the information about what databases exist on your server:
EXECÂ sp_helpdb
This returns:
Column name Data type Description name sysname Database name. db_size nvarchar(13) Total size of the database. owner sysnameDatabase…
View On WordPress










