Posted by keyvez on 06/01/06 17:33

I was having the same problem for months, so I decided to modify the
sys.sp_fkeys stored procedure and I found the problem, if you want a
fix, here's my modification

http://www2.keyvez.com:82/?q=node/12

keyvez@gmail.com wrote:
> I am trying to find the tables and columns that depends on 'table1'
>
> sp_fkeys @pktable_name='table1'
>
> and this takes about eight seconds, whereas if I run it for finding all
> tables and columns that 'table1' depends on
>
> sp_fkeys @fktable_name='table1'
>
> this only takes a second.
>
> How can I speed up the first stored procedure execution?

• Next in forum: Re: default value on quantity and price field
• Prev in forum: Re: How can I conserve the initial zero when convert numeric to string using STR()
• Thread view: Re: sp_fkeys stored procedue is very slow

[Reply to this message]