Posted by keyvez on 05/18/06 17:11

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: Copy a table from one DB to antoher in SQL Server 2005
• Prev in forum: Re: Using BLOB
• Thread view: sp_fkeys stored procedue is very slow

[Reply to this message]