View the database size

To view the current database size, execute the following TSQL:

declare @db sysname
select @db = db_name()
exec sp_helpdb @db