to figure out space used by tables. I have seen different versions of them .. here is a very simple effective one!!!
spaceused by user tables
sp_msforeachtable "sp_spaceused '?'; "
to figure out space used by tables. I have seen different versions of them .. here is a very simple effective one!!!
sp_msforeachtable "sp_spaceused '?'; "