I am a junior dba - still trying to learn as much as I can. I would
like to calculate the current size of my DB as well as my DB server. I
am currently using DBArtisan however would like to know the syntax/
commands for calculating the space of the items I mentioned above as
oppose to using the GUI.
Thank you
sp_helpdb dbname - gives you the size of the particular database .
When you say "size of server" are u looking for total size of all the
databases residing on the server ?
-HTH
Manish Negandhi
[TeamSybase]