Im new at SQL Sever, but i dont know if this question i may ask is simple or complicated.
I know in order to get the space used in any database is sp_spaceused,
Iwas asked to get the spaceused in any table(s) for instance in table_name1, table_name2
in my little knowledge i think its not easy because each table is determinated by filegroups and datafiles, and each datafile has more tables and other objects, isnt it?
so its not acuurate this analysys,
Just tell me, do i have to create any script or procedure to do that?
i know i have to do this by myself but if you have any ideas to guide through this process, id appreciate your help