T-SQL query to enumerate database size and Engine version (SQL Server)


To totally unlock this section you need to Log-in


Login

The following [gs query] will display the size of each DB available on the SQL Server actually analyzed (on which the query is executed).

NOTE: column's headers are written in italian, but this code will run smoothly on every SQL Server version. The query can be easily integrated with other SQL Server Engine versions (this query will recognize only 2005/2008 versions).

The query is not context-dependent, so it is not necessary to select master DB to run this query:

[tweet]


To totally unlock this section you need to Log-in


Login

1 thought on “T-SQL query to enumerate database size and Engine version (SQL Server)”

Comments are closed.