Hi Carlo,

I've just tried out your latest post, compared against my script.

Against a (random) sample stored procedure, yours retrieves 9 tables (listed below)

ATTR_LN_PTF_BENCH

BENCHMARK

D_TIME

PORTF_SHARE

PORTFOLIO

PORTFOLIO_PERFORMANCES

S_PORTF_SHARE_PERF

SHARE_PERF_SETTING

T_SHARE_CLASS

whereas mine retrieves 13 tables (also listed)

ATTR_LN_PTF_BENCH

BENCHMARK

D_TIME

PERF_CALENDAR

PORTF_SHARE

PORTFOLIO

PORTFOLIO_PERFORMANCES

S_PORTF_SHARE_CARAC

S_PORTF_SHARE_PERF

S_PORTFOLIO_CARAC

SHARE_NET_VALUE

SHARE_PERF_SETTING

T_SHARE_CLASS

I've checked the tables which aren't in your results and they are 1) not commented 2) not dynamic SQL.

I just want to reiterate that sysdepends is totally unreliable, and sp_MSdependencies is built on sysdepends. (Do an sp_helptext on it and search for sysdepends.)

ANY SOLUTION based on sysdepends isn't going to work.

Regards,

David.