how to know database size using query

select * from sys.dm_db_file_space_usage

or you can try...

exec sp_spaceused

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)