Could anybody remind please, how can I get the current database size having
the full access to this database and server? What's the SQL query?
What else helpful about the current database can I get using queries? Load,
statistics, what else?
Thanks,
Just D.Check out sp_spaceused in the BOL.
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
.
"Just D." <no@.spam.please> wrote in message
news:D_o%d.57888$xt.46304@.fed1read07...
Could anybody remind please, how can I get the current database size having
the full access to this database and server? What's the SQL query?
What else helpful about the current database can I get using queries? Load,
statistics, what else?
Thanks,
Just D.
Showing posts with label remind. Show all posts
Showing posts with label remind. Show all posts
Thursday, March 22, 2012
Subscribe to:
Posts (Atom)