On 1/27/2011 9:23 AM, m_brahim11 wrote:

>
> Is it possible to know by SQL in FB 2.5 what is the number of contexts
> used by a specific SP in order to prevent the
> Too many Contexts of Relation/Procedure/Views message ?
> I mean, the totally dependencies for a specfic SP.
>

Not by SQL. The restriction applies to a single query, not the
whole stored procedure, so you'll need to look at each query
individually and each view in each query and each view in each
view...

Good luck,

Ann