source code for system procedures

[#1]

where can i find the source code for predefined system procedure like CALL sa_table_page_usage(), CALL sa_table_stats(), CALL sa_table_fragmentation() etc..

[reimer_pods]

While you might view the source code using this SQL statement

select proc_defn 
from sys.sysprocedure 
where proc_name = 'sa_table_page_usage'

you won't get much information apart form the parameter declaration. System procedures call interal functions whose code isn't accessible.

[Former Member]

I appreciate your answer but i want to know the query behind the procedure call so then i can know which tables they are using.

[VolkerBarth]

System procedures call interal functions whose code isn't accessible.

I think that is different for different system procedures, some do contain their definition, others call internal procedures, and some do some stuff and then call internal procedures.